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