Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement