nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Walter Buggenhout

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!

All comments

Walter Buggenhout

Hi @Malavika L P,

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!

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.

Malavika L P

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud