JQL for issues worked on by a particular person, on a specific date range

[Erik Macias]

Hi,

Is it possible in Jira to search to see how many issues a particular person worked on for a particular day?

My initial guess is to try searching based on 'assignee' and 'updated' date, however that won't work if the Jira ticket was reassigned, or updated on a later date than the particular date I care about. 

I am open to plugin suggestions, like this one (this request might not justify purchasing a license though). However, if there are built in advance JQL filters or Scriptrunner filters, those methods would be preferred. 

We also have Tempo, if that would help (perhaps in reports?)

Thank you,

Erik

Jira - v.7.6.7
Scriptrunner - v5.5.0
Tempo Core - v.4.11.0

[Muhammad Ramzan(Atlassian Certified Master)]

This query will resolve your issue and you will get the issues where a person recorded hours during a day.  The trick/key here is the function loggedTimeByUser provided by the plugin 

if a person recorded their hours, this function will return the issues , now to filter the issues you need the updated date, as when they recorded the hours , date was updated so with the date filter it will give you the right results which is issues worked by a person within a specif date.

issue in loggedTimeByUser("username") and updatedDate <= endOfDay() and updatedDate>= startOfDay()

[Sebastian Krzewiński]

Hi @Erik Macias 

Did you try startOfDay and endOfDay functions?

assignee =username and resolutiondate <= endOfDay() and resolutiondate >= startOfDay()

This will show you what issues was resolved by specific users.

Regards,

Sebastian

[Erik Macias]

Hi @Sebastian Krzewiński,

Thanks for the response. This may work for issues that get resolved (I believe we require a resolution on most closed items). 

However, if the item was only worked on, but not closed/resolved, this may not work.

Erik

[Sebastian Krzewiński]

Hi @Erik Macias 

You are right. As I mention this JQL shows only issues that was resolved and assignee is certain users.

I think you should define what means work on issue. For me this mean:

- comment in issue - https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_commented

- log work on issue - https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_worklogged

- transition issue - I don't know that is JQL to list issues that was transition by users but I think you can use WAS or CHANGE operator if you know when exactly user can transition issue (e.g. in approvals).

Regards,

Sebastian

[Erik Macias]

Hi @Sebastian Krzewiński,

Good point, perhaps we haven't really defined what "worked on" means, or what changes specifically we are looking for (they may vary). On that note, would be you aware of any possible queries that can search based on any update (comment, transition, etc.)?

Let me go back and see what additional information I can gather.

Thanks for the feedback,

Erik