backend/com.tecknobit.refy.services.links.repository/LinksRepository/getCollectionLinks

get Collection Links

@Query(value = "SELECT l.* " + "FROM " + LINKS_KEY + " AS l " + "INNER JOIN " + COLLECTIONS_LINKS_TABLE + " ON " + COLLECTIONS_LINKS_TABLE + "." + LINK_IDENTIFIER_KEY + " = l." + LINK_IDENTIFIER_KEY + _WHERE_ + COLLECTIONS_LINKS_TABLE + "." + COLLECTION_IDENTIFIER_KEY + "=:" + COLLECTION_IDENTIFIER_KEY + " AND dtype = '" + LINK_KEY + "' " + " AND ( " + " MATCH(l." + TITLE_KEY + ", l." + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " + " OR :" + KEYWORDS_KEY + " = '' " + " )" + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )
abstract fun getCollectionLinks(    @Param(value = "collection_id") collectionId: String,     @Param(value = "keywords") keywords: String,     pageable: Pageable): List<RefyLink>

Method to execute the query to get all the links shared in a collection

Return

the collection links as List of RefyLink

Parameters

collectionId

The identifier of the collection from retrieve the links

keywords

The keywords used to filter the query to retrieve the items

pageable

The parameters to paginate the query