User Activity report: "Last Activity" column ignores the selected date-range filter #52

New Issue

2026-08-31T21:36:19-04:00

jared commented

2026-08-31 21:36:19 -04:00

Severity: Low

index.php (~lines 391-395): SELECT user_id, MAX(created_at) FROM audit_log GROUP BY user_id — this subquery has no WHERE clause on the selected date range at all, so it always shows true all-time last activity even when the page is filtered to e.g. "last 7 days," inconsistent with every other column on the same report.

Fix: Add the same date-range WHERE clause used by the report's other subqueries, or clearly label the column as "Last Activity (all-time)" if that's the intended behavior.

**Severity:** Low `index.php` (~lines 391-395): `SELECT user_id, MAX(created_at) FROM audit_log GROUP BY user_id` — this subquery has no `WHERE` clause on the selected date range at all, so it always shows true all-time last activity even when the page is filtered to e.g. "last 7 days," inconsistent with every other column on the same report. **Fix:** Add the same date-range `WHERE` clause used by the report's other subqueries, or clearly label the column as "Last Activity (all-time)" if that's the intended behavior.

jared added the priority/low reliability labels 2026-09-08 10:15:45 -04:00

jared referenced this issue from a commit

2026-09-08 11:59:38 -04:00

User Activity report: filter 'Last Activity' by the selected date range (#52)

jared referenced this issue from a commit

2026-09-08 15:39:42 -04:00

Merge development into main: 15-issue triage + fix batch

Sign in to join this conversation.