View TIMESHEET

Example

SELECT * 
FROM TABLE(EXAMPLES.TIMESHEET('admin', TIMESTAMP '2014-01-01 01:01:01', TIMESTAMP '2018-12-12 01:01:01'))

Definition

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