backend/com.tecknobit.refy.services.teams.repository/TeamsRepository/getCollectionTeams

get Collection Teams

@Query(value = "SELECT t.* FROM " + TEAMS_KEY + " AS t INNER JOIN " + COLLECTIONS_TEAMS_TABLE + " ON t." + TEAM_IDENTIFIER_KEY + "=" + COLLECTIONS_TEAMS_TABLE + "." + TEAM_IDENTIFIER_KEY + _WHERE_ + COLLECTIONS_TEAMS_TABLE + "." + COLLECTION_IDENTIFIER_KEY + "=:" + COLLECTION_IDENTIFIER_KEY + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )
abstract fun getCollectionTeams(@Param(value = "collection_id") collectionId: String, pageable: Pageable): List<Team>

Method to execute the query to get the teams where the collection is shared

Return

the user teams as List of Team

Parameters

collectionId

The identifier of the collection from retrieve the teams where is shared

pageable

The parameters to paginate the query