View MYWORKTODO

Owned by Piotr Bojko
Last updated: Jan 10, 2019
1 min read

Example

SELECT * FROM EXAMPLES.MYWORKTODO

Definition

SELECT 
	PROJECT, ISSUETYPE, COUNT(ISSUEKEY) ISSUES, AUX.ASDURATION(SUM(TIMEESTIMATE)) WORKTODO 
FROM
	TABLE(AUX.JQL(
		'PROJECTOBJECT PATH `name` AS `PROJECT`,ISSUETYPEOBJECT PATH `name` AS `ISSUETYPE`,ISSUEKEY,TIMEESTIMATE', 
		'assignee = currentUser() AND resolution = Unresolved'
	)) 
GROUP BY PROJECT, ISSUETYPE