count
All
User
Links
@Query(value = "SELECT ( " +
"SELECT COUNT(*) FROM " + LINKS_KEY + " AS l " + _WHERE_ +
" l." + OWNER_KEY + " = :" + USER_IDENTIFIER_KEY +
" AND dtype = '" + LINK_KEY + "'" +
" AND ( " +
" MATCH(l." + TITLE_KEY + ", l." + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " +
" OR :" + KEYWORDS_KEY + " = '' " +
" )" +
") + ( " +
"SELECT COUNT(*) " +
" FROM " + LINKS_KEY + " AS l " +
" LEFT JOIN " + COLLECTIONS_LINKS_TABLE + " ON " + COLLECTIONS_LINKS_TABLE + "." + LINK_IDENTIFIER_KEY
+ " = l." + LINK_IDENTIFIER_KEY +
" LEFT JOIN " + TEAMS_LINKS_TABLE + " ON " + TEAMS_LINKS_TABLE + "." + LINK_IDENTIFIER_KEY +
" = l." + LINK_IDENTIFIER_KEY +
" LEFT JOIN " + COLLECTIONS_TEAMS_TABLE + " ON " + COLLECTIONS_TEAMS_TABLE + "." + COLLECTION_IDENTIFIER_KEY +
" = " + COLLECTIONS_LINKS_TABLE + "." + COLLECTION_IDENTIFIER_KEY +
" LEFT JOIN " + MEMBERS_KEY + " ON " + COLLECTIONS_TEAMS_TABLE + "." + TEAM_IDENTIFIER_KEY + "=" +
MEMBERS_KEY + "." + TEAM_IDENTIFIER_KEY +
" OR " + TEAMS_LINKS_TABLE + "." + TEAM_IDENTIFIER_KEY + "=" + MEMBERS_KEY + "." + TEAM_IDENTIFIER_KEY +
" WHERE " + MEMBERS_KEY + "." + OWNER_KEY + " = :" + USER_IDENTIFIER_KEY +
" AND l.dtype = '" + LINK_KEY + "' " +
" AND ( " +
" MATCH(l." + TITLE_KEY + ", l." + DESCRIPTION_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " +
" OR :" + KEYWORDS_KEY + " = '' " +
" )" +
")",
nativeQuery = true
)
Method to count all the user's links, included the links shared in the teams and in the collections shared in the teams
Return
the count of the user links as long
Parameters
userId
The identifier of the user