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

Question

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_ · Answer

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()

Erik Macias_zr8s05 · Answer

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

Sebastian Krzewiński · Answer

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