get Note

@Query(value = ""SELECT * FROM " + NOTES_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + AUTHOR_KEY + "=:" + AUTHOR_KEY", nativeQuery = true )
abstract fun getNote(@Param(value = "author") authorId: String, @Param(value = "id") noteId: String): Note

Method to execute the query to select a Note by its id

Return

the note as Note

Parameters

authorId

The author identifier

noteId

The note identifier