nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter by Change of Status

Suzun Kaiser

I would like to create a filter so I can see a Dev's ticket history and if any of the tickets worked ever were in a specific status.

Example:

Ella has worked on 10 tickets over the course of her time here. I want to see if any of those tickets were ever in "feedback" status.

________________________________________________________________________________________

My current filter is:

Project: All

Type: All

Status: All

Assignee: Ella

Result: 10 tickets

Now - I want to see if any of those 10 tickets were ever changed to 'feedback' status at any point and time in the history of the ticket when Ella worked on it.

Thanks!

Accepted answers

All comments

Jack Brickey

You can use the following JQL for that

and status was feedback

you can add that snippet to your existing JQL to meet your needs

Suzun Kaiser

Thank you - without knowing JQL where do I to to find a way to write what I need?

Yuliia_Borivets__SaaSJet_

Hi @Suzun Kaiser

If you're open to using third-party apps, check out Issue History. It's developed by my team to monitor full issues changelog. You can view who and when changed issue statuses. So you'll know if tickets were ever changed and time in the history when Ella worked on it.

Just select a project and Ella or any assignee you need.

Hope you find the solution. Feel free to write if you have any questions.

Regards

Jack Brickey

In the basic search screen to the right you will see a link that says advanced search. If you click that it will convert your basic search into advance JQL. You could then add that snippet of JQL that I provided. If you click on that link and copy the contents of that JQL box into a reply here I could modify for you then you could cut paste.

Jack Brickey

Also you might reference this article to get you started into the world of advance searching - https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-searching-in-jira-cloud/

Suzun Kaiser

Thank you, I appreciate you sharing this with me.

Mehmet A _Bloompeak_

Hi @Suzun Kaiser ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Rahul_RVS

Hi @Suzun Kaiser

If you would be interested in a ready made solution, you may want to try out our plugin,

Agile Tools : Epic Tree & Time in Status

The add-on provides the time spent in each status for the entire lifecycle of the issue. You can also extract the transitions history of the issue. Along with various Issue stats reports, you get additional features like Epic Hierarchy & Links Hierarchy to track the project's progress. The main features are as below

More than 8 types of Time in Status Reports. Excel Export available for all status reports.
- Time in Status
- Time with Assignee
- Time in Status with Assignee
- Time with Assignee per Status
- Status/Assignee Count
- Multiple Transition Reports
- Avg Time reports
Epic Hierarchy / Sum Up (Standard Jira Hierarchy Epic -> Story -> SubTask)
Link Hierarchy / Sum Up (Hierarchy based on your issue link, upto 10 level deep)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

filter