How to query Epics having several fixVersions (Epic to fixVerstion spill over count)?

Question

Dear experts,

I have need to report Epics that passed multiple releases (fixVersions).
Is there JQL to extract epics that have more than 1 value in fixVersion or a calcfield to show number of fix versions assigned or any better idea to report?

Something similar to:

Prosper Agwegiokhe_wkahkr · Accepted Answer

Hi @Aquarius,

Welcome to the Atlassian Community!

I’m a support engineer at Appfire, here to assist you.

If you're open to plugin suggestions, I recommend trying our JQL Search Extension for Jira. It includes a helpful function to count the number of fixVersions in issues using the query:

fixVersionsCount > 1

For more details, feel free to refer to our documentation, and don't hesitate to contact our support team if you have any further questions. We're always happy to help!

Best regards,
Prosper

Bill Sheboy · Accepted Answer

Hi @Aquarius

Other than directly observing the list of Epics and their Fix Versions field using an issue search, there is nothing built-in to do this counting of values in a field.

Possible workarounds depend upon how often you need this type of search and willingness to spend money / invest effort:

* need one time* export the issues to a spreadsheet and perform the check the using formulas / pivot tables

* need often* willing to spend money* investigate the Atlassian Marketplace for an addon / app to add such search capabilities

* willing to invest effort* using custom fields and an automation rule, count the values in the field and store them, then use built-in JQL features to search on the custom field

Kind regards,
Bill