backend/com.tecknobit.refy.services.collections.repository/CollectionsRepository/getTeamCollections

get Team Collections

@Query(value = "SELECT c.* FROM " + COLLECTIONS_KEY + " AS c INNER JOIN " + COLLECTIONS_TEAMS_TABLE + " ON c." + IDENTIFIER_KEY + "=" + COLLECTIONS_TEAMS_TABLE + "." + COLLECTION_IDENTIFIER_KEY + _WHERE_ + COLLECTIONS_TEAMS_TABLE + "." + TEAM_IDENTIFIER_KEY + "=:" + TEAM_IDENTIFIER_KEY + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )
abstract fun getTeamCollections(@Param(value = "team_id") teamId: String, pageable: Pageable): List<LinksCollection>

Method to execute the query to get the collections shared with the team

Return

the user teams as List of Team

Parameters

teamId

The identifier of the team from retrieve the collections

pageable

The parameters to paginate the query