Example
| Code Block | ||
|---|---|---|
| ||
SELECT * FROM EXAMPLES.MYPLANNEDTOTALWORK |
Definition
| Code Block | ||
|---|---|---|
| ||
SELECT
AUX.ASPROJECTNAME(PROJECT) PROJECT, IT.NAME, COUNT(ISSUEKEY) ISSUES, AUX.ASDURATION(SUM(TIMEESTIMATE)) WORKTODO
FROM
TABLE(AUX.JQL('PROJECT,ISSUETYPE,ISSUEKEY,TIMEESTIMATE', 'assignee = currentUser() AND resolution = Unresolved')) jql
JOIN
ISSUETYPES IT ON jql.ISSUETYPE = IT.ID GROUP BY PROJECT, IT.NAME
GROUP BY PROJECT, IT.NAME |
...