backend/com.tecknobit.pandoro.services.groups.repositories/GroupsRepository/getAuthoredGroups

get Authored Groups

@Query(value = "SELECT * FROM " + GROUPS_KEY + " WHERE " + AUTHOR_KEY + "=:" + AUTHOR_KEY + " AND " + NAME_KEY + " LIKE %:" + NAME_KEY + "%" + " ORDER BY " + CREATION_DATE_KEY + " DESC ", nativeQuery = true )

abstract fun getAuthoredGroups(@Param(value = "author") userId: String, @Param(value = "name") name: String, pageable: Pageable): List<Group>

Method to execute the query to select the list of a Group where the user is the author of the group

Return

the list of groups as List of Group

Parameters

userId

The user identifier

pageable

The parameters to paginate the query

name

The name of the group to use as filter