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

Nina Andrić March 15, 2024

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?

4 answers

0 votes
Iryna Komarnitska_SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 18, 2024

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.

2024-03-18_18-05-09.png

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

2024-03-18_18-07-51.png

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

2024-03-18_18-10-45.png

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

2024-03-18_17-59-30.png

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!

0 votes
Gizem Gökçe _OBSS_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 18, 2024

Hello @Nina Andrić ,

If you are open to using an application specifically tailored to your needs, Time in Status 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.

Assignee Duration Per Status.png

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 Time in Status 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

0 votes
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 17, 2024

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:

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

 

 

0 votes
Harsh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 15, 2024

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ć March 15, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events