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

count User Owned Teams

@Query(value = ""SELECT DISTINCT COUNT(*) " + "FROM " + TEAMS_KEY + " as t INNER JOIN " + MEMBERS_KEY + " ON t." + TEAM_IDENTIFIER_KEY + "=" + MEMBERS_KEY + "." + TEAM_IDENTIFIER_KEY + _WHERE_ + "t." + OWNER_KEY + "=:" + USER_IDENTIFIER_KEY", nativeQuery = true )

abstract fun countUserOwnedTeams(@Param(value = "user_id") owner: String): Long

Method to count the user's owned teams

Return

the count of teams as long

Parameters

owner

The identifier of the owner