JQL for twin released fixVersions

Question

Hi, we have two production environments that are are somewhat out of sync in regard of feature releases. An issue gets two fixVersions "environment1-" and "environment2-". When we release a version in Jira, lets say "environment1-2.4.3" we would like to check if an issue having that fixVersion also has an "environmet2-X.Y.Z" version that is already released, which would lead to transitioning the ticket with Jira Automation. So JQL condition fixVersion ~ "environment2-*" AND fixVersion NOT IN unreleasedVersions() worked well untill we started adding more fixVersions not related to the environment-tags and that are not released. The condition above doesn't work since unreleasedVersions() grabs any fix version that is not released. Is it possible to check if an issue has a fixVersion matching "environment2-*" and if THAT fixVersion is released. We have other alternative mechanisms for solving the actual problem, but asking out of interest if the check above is plausible in Jira without addons?

Bill Sheboy · Answer

Hi @tehden33

Are you noting that you are adding other things (i.e. other versions) in the fixVersion field, to help manage other things than environment, and that those other things are released?

* If so, what do those things represent and is there another way to indicate them other than versions, which are typically used for release management?
* If not...I do not believe what you ask is possible with out of the box JQL.

My next question would be: what problem are you trying to solve by using that search?

If this is for just reporting, consider marketplace addons for JQL that may help.

If you are performing some action/edit on the issues based on the search, perhaps you could write an automation rule to help.  That would allow you to precisely identify the matching "environment2-*" version, and then determine if it is unreleased, released, archived, etc.

Kind regards,
Bill