SELECT 
	AUX.ASPROJECTNAME(PROJECT) PROJECT, IT.NAMEISSUETYPE, COUNT(ISSUEKEY) ISSUES, AUX.ASDURATION(SUM(TIMEESTIMATE)) WORKTODO 
FROM

	TABLE(AUX.JQL('PROJECT,ISSUETYPE
		'PROJECTOBJECT PATH `name` AS `PROJECT`,ISSUETYPEOBJECT PATH `name` AS `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.NAMEISSUETYPE