recent
Retrieve code findings updated at or after a specified date, with optional status filtering to track what changed since then.
Instructions
Findings TOUCHED at or after a date — the one call for "what closed since".
WHAT THIS MEASURES: updated_at, the time of the LAST WRITE to the row,
and not the moment the finding was closed. There is no close timestamp
anywhere in the schema. A status change moves updated_at, and so do a
re-tag, an AUTHORED meta patch, a severity re-triage, an append_note,
and a DEDUPLICATED OBSERVATION — a repeat report bumps the occurrence
count and stamps updated_at while the status stays exactly where it was.
AUTHORED is doing work in that sentence since CB-230: the tracker's own
housekeeping (refreshing a card's code anchor) writes meta WITHOUT
stamping, so a maintenance pass no longer floods this reader with every
card it touched.
So recent(since=..., status="fixed") means "cards that are fixed NOW and
were touched since that date", NOT "cards closed since that date". The
error is ONE-SIDED: false positives are possible, misses are not, because
closing a card always writes updated_at — guaranteed rather than merely
true, since housekeeping is refused outright when it carries a status.
Rows come back newest touch first, with rowid breaking the whole-second
ties updated_at produces, so a paged walk is stable.
Args:
since: Lower bound on
updated_at, INCLUSIVE. 'YYYY-MM-DD' or 'YYYY-MM-DDTHH:MM:SSZ'. REQUIRED — an unparseable value is refused rather than defaulted, because a silently widened window answers a question nobody asked.status: Filter by status (open, in_progress, fixed, not_a_bug, wont_fix, stale). Aliases accepted. Omit for every status. The
deferredpseudo-status ofqueryis NOT accepted here and is refused rather than ignored — usequeryfor it.limit: Max results (default 100). 0 means NO results. A negative value is an error (it used to mean "no limit"). The neighbouring
querytool answers the same argument the same way.offset: Pagination offset
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| since | Yes | ||
| offset | No | ||
| status | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||