Skip to end of metadata
Go to start of metadata
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