Mercurial > xmpp-ecosystem-data / changeset

--- 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;