Version history

{
  "query_kind": "sql",
  "query_body": "WITH recent_allocations AS (\n  SELECT content\n  FROM artifacts\n  WHERE artifact_type = 'resource_allocation'\n    AND is_latest = 1\n  ORDER BY created_at DESC\n  LIMIT 3\n),\nfunded_refs AS (\n  SELECT DISTINCT (alloc->>'target_ref') AS ref\n  FROM recent_allocations ra,\n       LATERAL jsonb_array_elements(\n         COALESCE(ra.content->'allocations', '[]'::jsonb)\n       ) AS alloc\n)\nSELECT a.id::text AS ref, a.title\nFROM artifacts a\nWHERE a.lifecycle_state = 'canonical'\n  AND a.is_latest = 1\n  AND a.artifact_type IN ('task', 'hypothesis', 'knowledge_gap',\n                          'gap', 'mission', 'challenge')\n  AND a.id NOT IN (\n    SELECT ref FROM funded_refs WHERE ref IS NOT NULL\n  )\n  AND COALESCE(a.lifecycle_state, '') = 'canonical'\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 10
  },
  "severity_default": "critical",
  "recommended_action_template": "{n} canonical work items have gone unfunded for ≥3 consecutive\nallocation periods. Re-review their EV scores or adjust the\nLLM cap via senate.resource.budget. First items: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}