Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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

...