backend/com.tecknobit.refy.helpers.services.repositories/TeamsRepository/getAllUserTeams

getAllUserTeams

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

abstract fun getAllUserTeams(@Param(value = "user_id") owner: String): List<Team>

Method to execute the query to get all the user's teams

Return

the user teams as List of Team

Parameters

owner

: the identifier of the owner