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