nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to find list of issues that have same fix version?

Ayush Ghuliani

I need help to automate releasing of a "release" but unable to fetch the issues that belong to a particular fix version using JQL in lookup issues option in Jira automation..

The objective is to trigger an automation to release a particular version once all the tasks part of that release are in status "Done/Deployed"

Accepted answers

Bill Sheboy

Hi @Ayush Ghuliani

The fix version field is a list of values, and the rule needs to handle that accordingly. And to use the membership IN operator the list of values needs to be in parentheses. Finally, do any of your fix versions' names contain spaces or special characters? If so, the names need to be wrapped with quotation marks.

Perhaps something like this for your rule:

project = NC
 AND issuetype = Task
 AND fixVersion IN ( {{#issue.fixVersions}}"{{name}}"{{^last}}, {{/}}{{/}} )

To learn more about list handling syntax in rules, please review this documentation:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/

Kind regards,
Bill

All comments

Raja Shekher

Hi @Ayush Ghuliani

If I understand the question correctly, then you need to enter the JQL in the following way

Project = XYZ and fixVersion="Your Version" and Status ="Done/Deployed"

Hope this helps!

Regards,

Raja

Ayush Ghuliani

Yes, and the fix version will be dynamic .

Tried using fixVersions IN {{issue.fixVersions}} but that does not give any result

earliestUnreleasedVersion() nextUnreleasedVersion() functions did not work for me either.

Raja Shekher

To generate the fix version in a dynamic way - please use like below

{{issue.fixVersions.name}} - Returns the name of the fix version.

Raja Shekher

This issue is part of the following releases:
{{#issue.fixVersions}}
* Fix version: {{name}}, released on {{releaseDate}}
{{/}}

// returns

This issue is part of the following releases:
• Fix version: Version 1.1, released on 2019-08-10T00:00:00.0+0000
• Fix version: Version 1.5, released on 2019-08-02T00:00:00.0+0000

Bill Sheboy

Hi @Ayush Ghuliani

Perhaps something like this for your rule:

project = NC
 AND issuetype = Task
 AND fixVersion IN ( {{#issue.fixVersions}}"{{name}}"{{^last}}, {{/}}{{/}} )

To learn more about list handling syntax in rules, please review this documentation:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/

Kind regards,
Bill

Ayush Ghuliani

Really appreciate your help with this one

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud