SELECT * 
FROM TABLE(EXAMPLES.JQLTIMESHEET('RESOLUTION IS EMPTY', TIMESTAMP '2014-01-01 01:01:01', TIMESTAMP '2018-12-12 01:01:01'))

SELECT 
	FLOOR(STARTDATE TO DAY) WORKDAY, 
	AUTHOR, 
	COUNT(W.ID) ENTRIES,
	AUX.ASTEXT(COLLECT(AUX.ASISSUEKEY(ISSUE))) ISSUES, 
	AUX.ASDURATION(SUM(TIMEWORKED)) WORKED, 
	SUM(TIMEWORKED) WORKED_IN_MS 
FROM CORE.WORKLOGS W 
JOIN TABLE(AUX.JQL('ID',?)) JQL on JQL.ID = W.ISSUE 
WHERE STARTDATE BETWEEN ? AND ? 
GROUP BY FLOOR(STARTDATE TO DAY), AUTHOR 
ORDER BY FLOOR(STARTDATE TO DAY) ASC