backend/com.tecknobit.pandoro.services.groups.repositories/GroupMembersRepository/getGroupMemberByEmail

get Group Member By Email

@Query(value = ""SELECT * FROM " + GROUP_MEMBERS_TABLE + " WHERE " + EMAIL_KEY + "=:" + EMAIL_KEY + " AND " + GROUP_MEMBER_KEY + "=:" + GROUP_MEMBER_KEY + " AND " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true )
abstract fun getGroupMemberByEmail(@Param(value = "id") memberId: String, @Param(value = "group_member") groupId: String, @Param(value = "email") email: String): GroupMember

Method to execute the query to select a GroupMember by its email

Return

the group member as GroupMember

Parameters

memberId

: the member identifier

groupId

: the group identifier

email

: the email of the member