updateJoiningQRCode
@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + JOINING_QRCODES_TABLE + " SET " + PROJECT_MEMBERS_TABLE + "=:" + PROJECT_MEMBERS_TABLE
+ " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to update an existing JoiningQRCode after a user join in a project and the allowed mailing list must remove the joined member
Parameters
joiningQRCodeId
: the identifier of the qrcode
projectMembers
: the emails of the members