updateJoiningQRCode

@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + JOINING_QRCODES_TABLE + " SET " + PROJECT_MEMBERS_TABLE + "=:" + PROJECT_MEMBERS_TABLE + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun updateJoiningQRCode(@Param(value = "id") joiningQRCodeId: String, @Param(value = "project_members") projectMembers: String)

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