add Change Note

@Modifying(clearAutomatically = true )
@Query(value = "INSERT INTO " + NOTES_KEY + " (" + IDENTIFIER_KEY + "," + AUTHOR_KEY + "," + CONTENT_NOTE_KEY + "," + CREATION_DATE_KEY + "," + MARKED_AS_DONE_KEY + "," + MARKED_AS_DONE_BY_KEY + "," + MARKED_AS_DONE_DATE_KEY + "," + UPDATE_KEY + ") " + "VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + AUTHOR_KEY + "," + ":" + CONTENT_NOTE_KEY + "," + ":" + CREATION_DATE_KEY + "," + "false," + "NULL," + "-1," + ":" + UPDATE_KEY + ")", nativeQuery = true )
abstract fun addChangeNote(@Param(value = "author") authorId: String, @Param(value = "id") noteId: String, @Param(value = "content_note") contentNote: String, @Param(value = "creation_date") creationDate: Long, @Param(value = "project_update") updateId: String)

Method to execute the query to add a new change note

Parameters

authorId

The author of the note identifier

noteId

The note identifier

contentNote

The content of the note

creationDate

The creation date of the note

updateId

The update identifier