Report/Query to track daily hours entered

[Rajasekhar Maddela]

Hello Community,

Sorry if this question was already discussed elsewhere on another thread but it would be very helpful if I could run a report (sort of) that shows how many hours each of the team members has burnt against their assigned tasks for the previous day. JIRA being not very flexible in terms of having a built-in report, I was wondering if anyone from the community has been able to do this and how. Maybe a plugin/query? Thanks in advance.

Regards,

Raj

[Alexey Matveev · Accepted solution]

Hello,

You would need the Tempo Timesheets plugin to get such a report:

https://marketplace.atlassian.com/apps/6572/tempo-timesheets?hosting=cloud&tab=overview

[Piotr Bojko]

With a little help of Smart QL plugin - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview

You can do following queries

SELECT AUX.ASISSUEKEY(issue), author, AUX.ASDURATION(timeworked) 
FROM worklogs 
WHERE startdate BETWEEN TIMESTAMP '2016-11-23 00:00:00' AND TIMESTAMP '2016-11-24 00:00:00'
LIMIT 3

You can of course do more precise queries, even mix JQL with SQL (and XPATH ).