diff options
| author | Peter Stone <thepeterstone@gmail.com> | 2026-01-13 09:10:20 -1000 |
|---|---|---|
| committer | Peter Stone <thepeterstone@gmail.com> | 2026-01-13 09:10:20 -1000 |
| commit | cb9577d586d9cb324b042a0c05d97d231f9c2e75 (patch) | |
| tree | fb3d644cb9db28b0110bdab421a69ef480b49dc4 /SESSION_STATE.md | |
| parent | fc4a3a0ea9a10c91b01f2b4e3857b367cb03ed78 (diff) | |
Implement Trello smart sorting by newest card activity
- Update GetBoards SQL query with LEFT JOIN and GROUP BY
- Sort by: 1) Has cards, 2) Newest card (MAX ID), 3) Board name
- Update GetBoardsWithCards to match SQL sorting behavior
- Leverage Trello ID chronological sortability (newer > older)
- Active boards with recent activity appear first
- All tests passing
Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
Diffstat (limited to 'SESSION_STATE.md')
| -rw-r--r-- | SESSION_STATE.md | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/SESSION_STATE.md b/SESSION_STATE.md index dd8e30f..4c03fb2 100644 --- a/SESSION_STATE.md +++ b/SESSION_STATE.md @@ -51,6 +51,13 @@ Frontend modernization with tabs, HTMX, and Tailwind build pipeline complete. - web/templates/partials/planning-tab.html: New tab for Trello boards - web/templates/partials/meals-tab.html: New tab for PlanToEat meals - Clean separation of concerns: Tasks (due items), Planning (all boards), Notes (knowledge), Meals (calendar) +- **Trello Smart Sorting:** Activity-based board ordering by newest card + - internal/store/sqlite.go:426-438: Updated GetBoards SQL query with LEFT JOIN and GROUP BY + - Sort order: 1) Has cards (COUNT > 0), 2) Newest card (MAX(c.id) DESC), 3) Board name (ASC) + - internal/api/trello.go:220-254: Updated GetBoardsWithCards sorting logic + - Finds maximum card ID in each board (Trello IDs are chronologically sortable) + - Active boards with recent activity appear first, inactive boards at bottom + - All tests passing (go test ./...) - **Build Pipeline:** npm + PostCSS + Tailwind configuration (replaced CDN) - package.json, tailwind.config.js, postcss.config.js, Makefile - Custom design system with brand colors (Trello, Todoist, Obsidian, PlanToEat) @@ -94,9 +101,8 @@ Frontend modernization with tabs, HTMX, and Tailwind build pipeline complete. - **Decision:** Unified Atom Model - Abstract all data sources (Trello, Todoist, Obsidian, PlanToEat) into a single `models.Atom` type for consistent handling, sorting, and rendering across the UI. ## 📋 Next Steps -1. **Phase 2 Step 3:** Trello smart sorting (activity-based, modification date). -2. **Phase 2 Step 4:** Todoist "due first" sorting. -3. **Phase 2 Remaining:** Obsidian search & categorization, visual overhaul (glassmorphism), write operations, PWA. +1. **Phase 2 Step 4:** Todoist "due first" sorting. +2. **Phase 2 Remaining:** Obsidian search & categorization, visual overhaul (glassmorphism), write operations, PWA. ## ⚠️ Known Blockers / Debt - None currently. |