Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 3 Current »

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
  • No labels