backend/com.tecknobit.refy.services.customlinks.repository/CustomLinksRepository/countUserCustomLinks

count User Custom Links

@Query(value = "SELECT COUNT(*) 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 + "=''" + " )", nativeQuery = true )

abstract fun countUserCustomLinks(@Param(value = "user_id") userId: String, @Param(value = "keywords") keywords: String): Long

Method to count the user's custom links

Return

the count of custom links as

Parameters

userId

The identifier of the user

keywords

The keywords used to filter the query to retrieve the items