Filter on changes in status. Not meaning changes in StatusCategory

jeroen.wilmes

I want to filter the issues that changed in status during a period (typically last week).

eg. I want to see what issues have transitioned into a certain status in the last week. 

 

For a statuscategory I can do that, using the date in "Statuscategory change date". But I want to have the same for different statuses withtin the statuscategory "open"

 

Is there anyway in doing that?

Hannes Obweger - JXL for Jira

Hi @jeroen_wilmes

just to add to Trudy's great answer: There is indeed no status change date available in Jira, at least not out of the box. If you want to perform a query on (or view) the exact change date/time value, I believe that you'll have to use extra tooling.

E.g., if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including the date of transition from [status] to [status].

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (e.g., Excel or Google Sheets) or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes