Mon, 13 Mar 2023 18:27:00 +0000
metadata: Add 'needs_deferral' canned query
metadata.yml | file | annotate | diff | comparison | revisions |
--- 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;