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

manage Change Note Status

@Modifying(clearAutomatically = true )

@Query(value = ""UPDATE " + NOTES_KEY + " SET " + MARKED_AS_DONE_KEY + "=:" + MARKED_AS_DONE_KEY + "," + MARKED_AS_DONE_BY_KEY + "=:" + MARKED_AS_DONE_BY_KEY + "," + MARKED_AS_DONE_DATE_KEY + "=:" + MARKED_AS_DONE_DATE_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + UPDATE_KEY + "=:" + UPDATE_KEY", nativeQuery = true )

abstract fun manageChangeNoteStatus(@Param(value = "project_update") updateId: String, @Param(value = "id") noteId: String, @Param(value = "marked_as_done") markedAsDone: Boolean, @Param(value = "marked_as_done_by") marker: String, @Param(value = "marked_as_done_date") markedAsDoneDate: Long)

Method to execute the query to manage the status of a change note

Parameters

updateId

The update identifier

noteId

The note identifier

markedAsDone

: whether the change note has been marked as done

marker

: who marks as done the change note

markedAsDoneDate

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