backend/com.tecknobit.refy.services.links.repository/LinksRepository/getTeamLinks

get Team Links

@Query(value = "SELECT l.* " + "FROM " + LINKS_KEY + " AS l " + "INNER JOIN " + TEAMS_LINKS_TABLE + " ON " + TEAMS_LINKS_TABLE + "." + LINK_IDENTIFIER_KEY + " = l." + LINK_IDENTIFIER_KEY + _WHERE_ + TEAMS_LINKS_TABLE + "." + TEAM_IDENTIFIER_KEY + "=:" + TEAM_IDENTIFIER_KEY + " AND dtype = '" + LINK_KEY + "' " + " AND ( " + " MATCH(l." + TITLE_KEY + ", l." + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " + " OR :" + KEYWORDS_KEY + " = '' " + " )" + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )
abstract fun getTeamLinks(    @Param(value = "team_id") teamId: String,     @Param(value = "keywords") keywords: String,     pageable: Pageable): List<RefyLink>

Method to execute the query to get all the links shared in a team

Return

the team links as List of RefyLink

Parameters

teamId

The identifier of the team from retrieve the links

keywords

The keywords used to filter the query to retrieve the items

pageable

The parameters to paginate the query