get
User
Custom
Links
@Query(value = "SELECT * FROM " + LINKS_KEY + _WHERE_ +
OWNER_KEY + "=:" + USER_IDENTIFIER_KEY +
" AND dtype='" + CUSTOM_LINK_KEY +
"' AND ( " +
" MATCH(" + TITLE_KEY + "," + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " +
" OR :" + KEYWORDS_KEY + "=''" +
" ) " +
"ORDER BY " + DATE_KEY + " DESC",
nativeQuery = true
)
Method to execute the query to get all the user's custom links
Return
the user custom links as List of CustomRefyLink
Parameters
userId
The identifier of the user
keywords
The keywords used to filter the query to retrieve the items
pageable
The parameters to paginate the query