Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Example

SELECT * FROM EXAMPLES.MYFILTERSTATS


Definition

SELECT
	F.NAME, \n" +
	COUNT(JQL.KEY) `ISSUE COUNT`
	MIN(JQL.CREATED) `OLDEST ISSUE`
	MAX(JQL.UPDATED) `MOST RECENT UPDATE`
FROM CORE.FILTERS F
CROSS JOIN LATERAL TABLE(AUX.JQL('KEY, CREATED, UPDATED', F.QUERY)) JQL
GROUP BY F.NAME
  • No labels