View MYFILTERS
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