SELECT
CEILFLOOR(W.STARTDATE TO DAY) DAYOFMONTHWORKDAY,
COUNT(W.ISSUE) ISSUECOUNT, (ID) ENTRIES,
AUX.ASTEXT(COLLECT(AUX.ASISSUEKEY(ISSUE))) ISSUES,
AUX.ASDURATION(SUM(W.TIMEWORKED)) WORKED,
SUM(TIMEWORKED) WORKED_IN_MS
FROM CORE.WORKLOGS WORKLOGSAS W
WHERE
W.AUTHOR = AUX.LOGGEDINUSER()?
AND EXTRACT(YEAR FROM W.STARTDATE) = EXTRACT(YEAR FROM CURRENT_TIMESTAMP)
AND EXTRACT(MONTH FROM W.STARTDATE) = EXTRACT(MONTH FROM CURRENT_TIMESTAMP)
GROUP BY CEIL(W.BETWEEN ? AND ?
GROUP BY FLOOR(STARTDATE TO DAY)
ORDER BY FLOOR(STARTDATE TO DAY) ASC |