Skip to end of banner Go to start of banner

View MYWORKTODO

Skip to end of metadata

Created by Piotr Bojko, last modified on Jan 10, 2019

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Example

SELECT * FROM EXAMPLES.MYPLANNEDTOTALWORK

Definition

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

No labels