JQL query to show all unreleased versions with 'done' issues

[Sarah Woods]

Can someone help me write a JQL query please.

We have multiple versions open at the same time as we use the 'release' feature for multiple applications to track our live deployments.

What I would like is to save a filter that shows all unreleased versions, where all of the issues with that fix version are 'done'. I would like to report on the versions that are 'done' and therefore ready to be released.

Thanks

[Nic Brough -Adaptavist- · Accepted solution]

I'd use a filter for "fixVersion in unreleasedVersions(xyz) and status = done" (xyz = a project name) to find the issues, then I'd stick the saved filter on a dashboard, in a filter statistics gadget, grouped by version - this will give you a list of unreleased versions with a count of the number of "done" issues in each.

[Anne Frederick]

This suggestion worked great for me! Thank you.

[Andrea Ogrodowicz]

I'm trying this but it's not letting me put the project name in the (xyz) ...any tips?

[Andrea Ogrodowicz]

Nevermind- seems to be working now. Thanks!

[Jack Brickey · Accepted solution]

Is this what you are looking for?

fixVersion in unreleasedVersions() and status = Done

[Sarah Woods]

Thanks Jack, I was hoping there was a way I could do this with a JQL query. Do you not think that's possible?

[Jack Brickey]

that is a JQL query. If you want you can add more to it to meet your needs. Otherwise just paste that into the advanced search bar and see if it works.

[Sarah Woods]

I mean only using a JQL query. 

I don't really want to be using dashboards and gadgets as you've suggested.

[Nic Brough -Adaptavist-]

JQL returns lists of issues, not versions.  The only way to do what you want is to use JQL to find issues and then report on them in a gadget on a dashboard.

[Mobily Monks]

@Sarah Woods  

JQL Extenstions  plugin may help you in your use-cases.  Refer documentation

I am also using it to fetch release version info. for multiple applications to keep a track of our deployments.