...
Code Block | ||
---|---|---|
| ||
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 |
...