removeMemberFromMailingList

@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + JOINING_QRCODES_MEMBERS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + EMAIL_KEY + "=:" + EMAIL_KEY", nativeQuery = true)
abstract fun removeMemberFromMailingList(@Param(value = "id") joiningQRCodeId: String, @Param(value = "email") email: String)

Method to execute the query to delete from an existing JoiningQRCode an email of a member invited with that joining qrcode

Parameters

joiningQRCodeId

: the identifier of the qrcode

email

: the email of the member to remove