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

get Group

@Query(value = ""SELECT " + GROUPS_KEY + ".* FROM " + GROUPS_KEY + " AS " + GROUPS_KEY + " INNER JOIN " + GROUP_MEMBERS_TABLE + " ON " + GROUPS_KEY + "." + IDENTIFIER_KEY + " = " + GROUP_MEMBERS_TABLE + "." + GROUP_MEMBER_KEY + " WHERE " + GROUP_MEMBERS_TABLE + "." + IDENTIFIER_KEY + "=:" + AUTHOR_KEY + " AND " + GROUPS_KEY + "." + IDENTIFIER_KEY + "=:" + GROUP_IDENTIFIER_KEY", nativeQuery = true )

abstract fun getGroup(@Param(value = "author") userId: String, @Param(value = "group_id") groupId: String): Group

Method to execute the query to select a Group by its id

Return

the group as Group

Parameters

userId

The user identifier

groupId

The group identifier