Query for all tasks that were assigned to a person in specific status

[Nina Andrić]

I want to create a query with a list of tasks that were assigned to a specific person in a specific sprint while in status "In progress" (or any other specific status).

When I use assignee WAS person_x it lists me all the tickets when that person was assigned in any status, but I want to limit it to only specific status (something like assignee WAS person_x WHEN status WAS "In progress", but JQL does not work that way :))

Have somebody tried to do something similar?

[Iryna Komarnitska_SaaSJet_]

Hi @Nina Andrić ,

If I have understood you correctly, then perhaps your request can be resolved in this way:

A report can be generated as a pivot using the Time in Status for Jira—Reports | Charts | Dashboard app developed by my team.

You need to select the Time in Status report and filter the tasks by a specific sprint.

Next, switch to the pivot mode, and in the Fields option, configure the report as shown in the screenshot.

When setting up the Status field, select only the one you need. In this case, it is In Progress.

And with the help of conditional formatting, you can highlight all values for easier formatting.

You will then get a report that shows all the Assignees whose tasks were in the In Progress status in a particular sprint.

We offer you a 30-day trial to get to know the Time in Status app as well as possible.

I hope you find it useful!

[Gizem Gökçe _OBSS_]

Hello @Nina Andrić ,

If you are open to using an application specifically tailored to your needs, Timepiece - Time in Status for Jira which is developed by my team at OBSS, is the tool I would highly recommend. It is available for both Jira Cloud, and Data Center. 

Time in Status provides the Assignee Duration Per Status report for your case. 

Using this report you can easily see who is OR was assigned to an issue in a particular status. The most important feature of this report is that if an issue is assigned to more than one assignee in a status, it shows all assigned assignees in turn. Please see the screenshot below.

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.  Also you can export the reports in to various formats easily. 

Visit Timepiece - Time in Status for Jira to explore how our JIRA add-on can revolutionize your reporting process. Enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Kind Regards,

Gizem

[Ste Wright]

Hi @Nina Andrić 

This isn't possible natively.

The data will be in the issue's history - you could look to use the API to access this, or use an App to view the data as required.

I'd trial either an Issue History App or a Reporting App from the Marketplace - such as:

• Issue History for Jira 
• Issue History Collector - See History 
• Custom Charts
• eazyBI 
• ...etc

Because what you want is quite custom, you might need to either trial different apps to see if they meet your needs - or contact the App vendors to ask if what you require is viable.

Ste

[Harsh]

Hi @Nina Andrić 

To filter all the tickets where assigned to one person you can use -

Project= Xyz and status in ("in progress", "done") and assignee = "1234" 

Status in () is used when you want to look for the assignee is Multiple Status

But if you want to search in only status you can use -

Project= Xyz and Status= "in progress" and assignee = "12345"

I hope this helps you with your problem. 

[Nina Andrić]

Unfortunately not, this is not what I need. This query would just give me all the tickets that are currently in that status assigned to that person.

The tickets I’m looking for might be already Closed. I want to know which tickets in Sprint X person Y was working on. So only when that person was assigned to a ticket in “In progress” status because in our workflow before the ticket closes there will be 3-4 more assignees on the same ticket (reviewer, developer that is deploying, delivery manager, QA, etc.)

[Harsh]

Hi @Nina Andrić 

Unfortunately Jira does not allow that. Like you mentioned the assignee will be changed on the ticket irrespective of the status. The only to is to manually look at the history.

Thank you