DEV-000066 prefer recent response candidates

Promote DEV-000066 response candidate window
DEV-000066 response candidate window follow-up
2026-08-17 17:37:20 +03:00 · 2026-08-17 14:33:57 +00:00
1 changed files with 1 additions and 1 deletions
@@ -227,7 +227,7 @@ func (r *ContinuityRepository) ResponseCandidates(ctx context.Context, owner ide
 		WHERE p.owner_principal_id=$1
 		  AND (a.attention_item_id IS NULL OR a.state IN ($3,$4,$5))
 		  AND p.state IN ($6,$7)
-		ORDER BY COALESCE(a.delivered_at_unix_millis,0) DESC, p.trigger_at_unix_millis DESC, p.prospective_item_id DESC
+		ORDER BY p.recorded_at DESC, COALESCE(a.delivered_at_unix_millis,0) DESC, p.prospective_item_id DESC
 		LIMIT $8`,
 		owner, continuity.AttentionSourceProspectiveReminder, continuity.AttentionDelivered, continuity.AttentionPending,
 		continuity.AttentionFailed, continuity.ProspectiveDelivered, continuity.ProspectiveArmed, limit)
Author	SHA1	Message	Date
m	465a90b25d	DEV-000066 prefer recent response candidates CI / test (push) Successful in 16s Details CI / test (pull_request) Successful in 16s Details	2026-08-17 17:37:20 +03:00
m	95d6ad2d6a	Promote DEV-000066 response candidate window CI / test (push) Successful in 19s Details DEV-000066 response candidate window follow-up	2026-08-17 14:33:57 +00:00