Example
Code Block | ||
---|---|---|
| ||
SELECT * FROM EXAMPLES.MYFILTERSTATSMYFILTERS |
Definition
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 |
...