# HG changeset patch
# User Matthew Wild <mwild1@gmail.com>
# Date 1678732020 0
# Node ID 07136e6644cca02aa076dee97ec5aab565be3b03
# Parent  e245cf75db68e4471058203d09e84c74bcff2d4b
metadata: Add 'needs_deferral' canned query

diff -r e245cf75db68 -r 07136e6644cc metadata.yml
--- a/metadata.yml	Mon Mar 13 17:56:43 2023 +0000
+++ b/metadata.yml	Mon Mar 13 18:27:00 2023 +0000
@@ -116,3 +116,18 @@
             xeps.number is null
           order by
             last_updated desc;
+      needs_deferral:
+        title: "XEPS: Due deferral"
+        description: "XEPs that are still Experimental but not updated for over a year"
+        sql: |-
+          select
+            xeps.number,
+            xeps.title,
+            xeps.last_updated
+          from
+            xeps
+          where
+            xeps.status = "Experimental"
+            and xeps.last_updated <= date('now','-12 months')
+          order by
+            xeps.last_updated asc;