How to retrieve the time spent by a user in a specified date range for a project using JQL

[Ravi Vangala]

Hi all,

I am working on measuring the productivity of the development team based on time taken to resolve the issues in a specific date range. My objective here is to know how much time a developer has spent to resolve the issue. Here I am interested to look at the data available from the start of year 2018. I am relying on JQL to get this extract as I could get relevant information using the below query in October 2017.

project in ("First Project", "Second Project") AND issuetype in (Bug, Story, Task) AND status = Done AND updatedDate >= startOfYear() AND worklogAuthor = <<user name>>

The above query shows no results as soon as I add the worklogAuthor in the query. This is an incorrect output as I know there are many items the individual has worked on from the star of year and also has logged work upon them. I believe there is some issue with worklogAuthor field as I have verified for many users across our organization.

Could anyone help me build the correct query or alternate of worklogAuthor field to achieve my objective! 

If it helps, we use Tempo for tracking the worklogs and recording them. In the specific JIRA issue, earlier it used to display worklogAuthor = <<user name>>, from the last few months it shows Timesheet made changes, it is no longer displaying the user who made changes.

Thank you in advance.

[Thomas Deiler]

Dear @Ravi Vangala,

I have validated both Jira Server and Jira Cloud. Your query seems to be correct. You could replace updatedDate with worklogDate.

I recommend to contact the plugin vendor, if you problem still exists.

So long

Thomas