backend/com.tecknobit.pandoro.services.notes.repository/NotesRepository/setGroupNotesAuthorAfterUserDeletion

set Group Notes Author After User Deletion

@Modifying(clearAutomatically = true )

@Query(value = "UPDATE " + NOTES_KEY + " SET " + AUTHOR_KEY + "= NULL" + " WHERE " + AUTHOR_KEY + "=:" + IDENTIFIER_KEY + " AND " + UPDATE_KEY + " IS NOT NULL", nativeQuery = true )

abstract fun setGroupNotesAuthorAfterUserDeletion(@Param(value = "id") userId: String)

Method to execute the query to remove the constraints between PandoroUser deleted and the author of the Note

Parameters

userId

The user identifier