issue filter that is showing me all open issues from the past/future releases.

[Henning Zobel]

Hello,

i need some help. I am searching for a issue filter that shows me the open issues from the past releases. The release is set as attribute fix version. 

I want to have an a solution that is automatically updating the releases in the past according the acutal date. I do not want to have a solution where i always have to change and select manual the fix version.

Hope you understand me and that you can provide me a solution or ideas. 

kind regards Henning

[Hannes Obweger - JXL for Jira]

Hi @Henning Zobel

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this should be easy to do using 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 smart columns that aren’t natively available, including the first version release date.

This is how it looks in action:

As you can see above, you can easily sort and filter by the fix version release date, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

In my example, I'm filtering down to all issues with a fix version release date in the past 365 days - but you can perform any filter operation that you want.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know!

Best,

Hannes

[Henning Zobel]

@Hannes Obweger - JXL for Jira but this is something i have to do manual. I would like to have a filter that is showing me from today all fixversions with a release date in the past

[Vishal Biyani]

@Henning Zobel 

Your question is not clear.

You can use either of the two conditions in the jql. to get list of issues that are tagged to a release which is not closed or has been marked as Released.

• fixVersion in unreleasedVersions() and statusCategory != Done

• fixVersion in releasedVersions() and statusCategory != Done

if this is not what you are looking for, can you further elaborate your question with an example

[Henning Zobel]

Thanks but that does not solve my problem. 

I have one project. In that project i have multiple fix versions. In those versions i have multiple issue types. 

What i want to get is a list of all open issue types in the fix version that has the finish date in the past. 

Additionally i need a list of all problem tickets planned in future fix versions.

Is this more understandable?

[Vishal Biyani]

@Henning Zobel 

I doubt it can be done via JQL.

Are you open to use REST APIs to get the required data programmatically?

[Henning Zobel]

@Vishal Biyani in principal yes, for me personal it is not a problem. But I do not know how it works in general. 

How would it work?