How to find time logged between two date in Jira

[Malavika L P]

Hi All,

I wanted to get the time logged to a particular project by a particular user for a specific period of time. I tried the below query and found that the workload was 955.92 hrs. However, when I cross-checked the same with the timesheet (Activity timeline application) there is a difference of 207.08. In the timesheet its actually 1163 hrs.

project = ABC AND worklogDate >= "2021/09/01" AND worklogDate <= "2022/06/26" AND worklogAuthor = XYZ order by created DESC

Can you guys help me out how to get it correctly on the dashboard.

[Walter Buggenhout · Accepted solution]

Hi @Malavika L P,

Trust you timesheet application for this. The problem with JQL (when speaking about time tracking) is that it retrieves issues, and not worklogs. While there is nothing wrong with your filter, it retrieves all issues that have worklogs during the given time frame. But it also returns all the time spent against those issues, even if it was logged outside those dates.

That is why there are so many apps in the marketplace that focus on reporting and tracking worklogs beyond Jira's built in functionality.

Hope this helps! 

[Malavika L P]

@Walter Buggenhout  Thank you for your reply. Yes it completely make sense.

[Nataliya Vasyliv_Reliex_]

Hi @Malavika L P

Thank you for your question. 
One additional case to what Walter said, is that ActivityTimeline app supports extra items that could be treated as Worklogs: Bookings.
So, if you have Bookings scheduled on the timelines of users in the past then they could be treated just like Worklogs that won't be visible to the Jira gadget.

This is controlled by the following ActivityTimeline setting:
ActivityTimeline Configuration -> Timesheets Config -> Treat Booking items as worklogs (screenshot below)

You may uncheck that checkbox and click Update button so tell ActivityTimeline to ignore Booking items in the past and do not calculate their hours into user's total worklog hours.

Regards,
Nataliya

[Malavika L P]

Hi @Nataliya Vasyliv_Reliex_  I checked the same when I found this discrepancy and noticed that it is un-checked and also cross checked it with my manager at any point of time if this option was checked and got confirmed that the option was not yet used. But I appreciate your time for the answer.