diff options
Diffstat (limited to 'src/server/repositories/note.ts')
| -rw-r--r-- | src/server/repositories/note.ts | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/server/repositories/note.ts b/src/server/repositories/note.ts index 52cbf9b..eb1aa28 100644 --- a/src/server/repositories/note.ts +++ b/src/server/repositories/note.ts @@ -22,7 +22,8 @@ export const noteRepository: NoteRepository = { const result = await db .select() .from(notes) - .where(and(eq(notes.deckId, deckId), isNull(notes.deletedAt))); + .where(and(eq(notes.deckId, deckId), isNull(notes.deletedAt))) + .orderBy(notes.createdAt); return result; }, @@ -52,7 +53,8 @@ export const noteRepository: NoteRepository = { const fieldValuesResult = await db .select() .from(noteFieldValues) - .where(eq(noteFieldValues.noteId, id)); + .where(eq(noteFieldValues.noteId, id)) + .orderBy(noteFieldValues.noteFieldTypeId); return { ...note, @@ -219,7 +221,8 @@ export const noteRepository: NoteRepository = { const allFieldValues = await db .select() .from(noteFieldValues) - .where(eq(noteFieldValues.noteId, id)); + .where(eq(noteFieldValues.noteId, id)) + .orderBy(noteFieldValues.noteFieldTypeId); return { ...updatedNote, |