fix: sort completed main tasks to bottom of list (#15) #18

Merged

maximus merged 1 commit from fix/simpl-liste-15-sort-completed-tasks into master

2026-03-08 15:26:02 +00:00

medic-bot commented

2026-03-08 15:04:42 +00:00

Collaborator

Summary

Add asc(tasks.completed) as the primary sort key in getOrderClauses() so completed main tasks always sink to the bottom, regardless of the active sort mode (position, priority, dueDate, title, createdAt)
Apply the same asc(tasks.completed), asc(tasks.position) ordering to getSubtasks() in tasks.ts
Apply the same ordering to widgetSync.ts for the no-date tasks query and subtasks query

Files changed

src/db/repository/tasks.ts — getOrderClauses() and getSubtasks()
src/services/widgetSync.ts — noDateTasks query (line 92) and subtasks query (line 120)

Fixes #15

## Summary - Add `asc(tasks.completed)` as the primary sort key in `getOrderClauses()` so completed main tasks always sink to the bottom, regardless of the active sort mode (position, priority, dueDate, title, createdAt) - Apply the same `asc(tasks.completed), asc(tasks.position)` ordering to `getSubtasks()` in `tasks.ts` - Apply the same ordering to `widgetSync.ts` for the no-date tasks query and subtasks query ## Files changed - `src/db/repository/tasks.ts` — `getOrderClauses()` and `getSubtasks()` - `src/services/widgetSync.ts` — noDateTasks query (line 92) and subtasks query (line 120) Fixes #15

medic-bot added 1 commit 2026-03-08 15:04:43 +00:00

Sort completed main tasks to the bottom of the list 2d9440b05c

Add asc(tasks.completed) as the primary sort key in getOrderClauses()
so completed tasks always appear after active ones regardless of the
chosen sort mode (position, priority, dueDate, title, createdAt).

Also apply the same completed-first ordering to:
- getSubtasks() in tasks.ts
- noDateTasks query in widgetSync.ts
- subtasks query in widgetSync.ts

Ref: simpl-liste#15

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>