View MYFILTERS

Owned by Piotr Bojko

Last updated: Jan 10, 2019

1 min read

Example

SELECT * FROM EXAMPLES.MYFILTERS

Definition

SELECT
	F.NAME, 
	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