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

manage Note Status

@Modifying(clearAutomatically = true )
@Query(value = ""UPDATE " + NOTES_KEY + " SET " + MARKED_AS_DONE_KEY + "=:" + MARKED_AS_DONE_KEY + "," + MARKED_AS_DONE_BY_KEY + "= NULL," + MARKED_AS_DONE_DATE_KEY + "=:" + MARKED_AS_DONE_DATE_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + AUTHOR_KEY + "=:" + AUTHOR_KEY", nativeQuery = true )
abstract fun manageNoteStatus(    @Param(value = "author") authorId: String,     @Param(value = "id") noteId: String,     @Param(value = "marked_as_done") markedAsDone: Boolean,     @Param(value = "marked_as_done_date") markedAsDoneDate: Long)

Method to execute the query to manage the status of a Note

Parameters

authorId

The author of the note identifier

noteId

The note identifier

markedAsDone

: whether the note has been marked as done

markedAsDoneDate

The date when the note has been marked as done or -1 if not