T2+ artifacts with no falsification attempt after 14d

Details

query_kind: sql
severity_default: attention
recommended_action_template: {n} T2+ artifact(s) are older than 14 days with no falsification_attempt. Invite a suitable Falsifier round for: {refs[:5]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

SELECT (a.artifact_type || ':' || a.id::text) AS ref, a.title
FROM artifacts a
WHERE a.epistemic_tier IN ('T2', 'T3', 'T4', 'T5')
  AND a.is_latest = 1
  AND a.created_at < NOW() - INTERVAL '14 days'
  AND NOT EXISTS (
    SELECT 1
    FROM artifacts fa
    WHERE fa.artifact_type = 'falsification_attempt'
      AND fa.is_latest = 1
      AND COALESCE(fa.lifecycle_state, 'active') != 'withdrawn'
      AND fa.content->>'target_ref' = (a.artifact_type || ':' || a.id::text)
  )

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 100
}

T2+ artifacts with no falsification attempt after 14d

Details

Replication

Discussion