Pipeline redesign: days in the current stage, from the status history #1200

New issue

Open

opened 2026-11-01 14:17:39 +00:00 by tiagoagueda · 0 comments

tiagoagueda commented

2026-11-01 14:17:39 +00:00

Owner

Part of #1191. Used by the Pipeline board and the application page ("21 DAYS IN STAGE", "9D in stage").

What

A queryset annotation: the date the application entered its current status, read from its newest status-change event. "Days in stage" is then a template filter on that date, in the person's time zone.
No per-card query: one annotated query feeds the board.
Applications with no status history (imported, or created at their status) count from their creation date.

Acceptance

Unit tests cover the cases: changes back and forth, same-day changes, imported applications.
The board's query count is pinned by a test.

🤖 Generated with Claude Code

Part of #1191. Used by the Pipeline board and the application page ("21 DAYS IN STAGE", "9D in stage"). ## What - **A queryset annotation:** the date the application entered its current status, read from its newest status-change event. "Days in stage" is then a template filter on that date, in the person's time zone. - **No per-card query:** one annotated query feeds the board. - **Applications with no status history** (imported, or created at their status) count from their creation date. ## Acceptance - Unit tests cover the cases: changes back and forth, same-day changes, imported applications. - The board's query count is pinned by a test. 🤖 Generated with [Claude Code](https://claude.com/claude-code)

tiagoagueda added this to the 0.7.0 milestone

2026-11-01 14:17:39 +00:00

tiagoagueda added the

performance

enhancement

labels

2026-11-01 14:17:39 +00:00

tiagoagueda referenced this issue

2026-11-01 14:17:43 +00:00

Pipeline redesign: the Pipeline board #1205

tiagoagueda referenced this issue

2026-11-01 14:17:43 +00:00