JQL Query for more than one fix version

[Ramesh Krishnan]

i wanted to find story has more than one fix version.

Example: Fixversion =2Version, 3 Verstion, i wanted to pull those story alone.

[sanam malleswari]

Hi @Ramesh Krishnan

If you have script runner, please use below query.

JQL Query: issueFunction in hasMultipleFixVersions()

[Hannes Obweger - JXL for Jira]

Hi @Ramesh Krishnan

to the best of my knowledge, this isn't possible in native JQL/Jira. The only workaround that I could think of is to use Jira Automation to write the fix version count into a custom field (of type number), and then use this custom field to filter your issues. Obviously, this would complicate your setup quite a bit, so I wouldn't personally recommend it.

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll have a number of options available. I'll add more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on the above:

If you're open to solutions from the Atlassian Marketplace, your use case would be easy to solve 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 number of fix versions.

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of fix versions, 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.

Once you've narrowed down your list of issues, you can work on these directly in JXL, trigger various operations in Jira, or export them for further processing.

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

Any questions just let me know!