SELECT p.name as projectName, p.`key` AS projectKey, CAST(SUM(timeSpentSeconds) / 3600 AS DECIMAL(10, 2)) as timeSpent FROM worklog w INNER JOIN project p ON p.`key` = SUBSTRING_INDEX(w.issueKey, '-', 1) WHERE w.start >= DATE_ADD(LAST_DAY(DATE_SUB(NOW(), INTERVAL 2 MONTH)), INTERVAL 1 DAY) and w.start < DATE_ADD(LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 MONTH)), INTERVAL 1 DAY) GROUP BY p.`key` ORDER BY timeSpent DESC;
Comments
0 B
|👍
/👎
0 B
|👍
/👎