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

get All User Teams

@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 + " AND ( " + " MATCH(t." + TITLE_KEY + ", t." + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " + " OR :" + KEYWORDS_KEY + " = '' " + ")" + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )
abstract fun getAllUserTeams(    @Param(value = "user_id") owner: String,     @Param(value = "keywords") keywords: String,     pageable: Pageable): 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

pageable

The parameters to paginate the query

keywords

The keywords used to filter the query to retrieve the teams