Time Spent Field is not showing data as per JQL

Amit Vaidya_h88bmy

Hi Team,

We are using following JQL to get time spent log for June 2020 month for specific user.

project = UTSMS AND (worklogDate >= "2020/06/01" AND  worklogDate <"2020/06/29" ) AND worklogAuthor = currentUser() and key="UTSMS-186" ORDER BY priority DESC, updated DESC

but when we are checking for specific isuses, time spent showing all the work log done by all the users. Can you please help to get exact time spent by specific user and for specific month?

Thanks,

Amit

Petter Gonçalves

Hello @Amit Vaidya

Thank you for reaching out.

Per your description, I understand you expect the JQL query you created to only display the worklog entries from the author you selected when opening the issues returned. Is that correct?

I believe you might be misunderstanding how the JQL search works in Jira, which can totally happen due to the complexity of the Jira application. Please, allow me to provide you with some concepts so we can confirm we are on the same page:

The JQL search in Jira was created with the single purpose to return issues based on the specific parameters added in the filter. That being said, the filter parameters are only applied to issues, not to other fields (like Time spent, Summary, etc).

Because of the concept above, the JQL you created will return all the issues that you have logged work, however, it will not filter the worklog added from other users or hide any other details in the issues returned.

That being said, we understand that a JQL query to return the work logs of a specific user would be useful for reporting purposes, so we created the following feature request to get this implemented:

Ability to add Worklog components as columns when viewing results with 'List View' 

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

Some options to create the report as you need:

1. You can export your issues to CSV and create an external report with the worklog entries
2. Use a third-party app that provides you with the worklogs of specific users over a specific amount of time. Here are some options:

Time Reports

Worklogs - Time Tracking and Reports 

Let us know if you have any questions.