backend/com.tecknobit.refy.services.collections.repository/CollectionsRepository/getUserOwnedCollections

get User Owned Collections

@Query(value = "SELECT * FROM " + COLLECTIONS_KEY + _WHERE_ + OWNER_KEY + "=:" + USER_IDENTIFIER_KEY + " ORDER BY " + DATE_KEY + " DESC", nativeQuery = true )

abstract fun getUserOwnedCollections(@Param(value = "user_id") userId: String, pageable: Pageable): List<LinksCollection>

Method to execute the query to get the user owned collections

Return

the user collections as List of LinksCollection

Parameters

userId

The identifier of the user

pageable

The parameters to paginate the query