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

count Collection Teams

@Query(value = ""SELECT COUNT(*) 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", nativeQuery = true )

abstract fun countCollectionTeams(@Param(value = "collection_id") collectionId: String): Long

Method to count the teams where the collection is shared

Return

the count of teams as long

Parameters

collectionId

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