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; } } }

Automatically Generate List of Fix Versions for the Current Month

Hunter1428

Hi everyone,

I'm trying to generate a list using jira automatons of all the fix versions scheduled or have released in the current month.

JQL: fixVersion in releaseDate("after startOfMonth() before startOfMonth(1)")

Currently I'm using this below for now. Sadly it's producing duplicates as it's running on each issue.

{{#issues.fixVersions}} {{name}} {{/}}

Note: We have an older version of automatons on our instance, no lookup.

Is there a better way or a way to fix the duplicate issue I'm getting?

Thanks!

Accepted answers

Hunter1428

Hello again!

So we finally moved to our new data centre and are now on version v9.12.7.

All the options you have given work so thank you for the help on these!

Quick question:
What would be the best way to put each value onto a new line or in a table format?

Tying to create a report like this within an email.

Released on 15th Dec - Version 1
Released on 18 Dec - Version 2
Released on 27 Dec - Version 3

I tried to generate a simple list but this keeps returning blank.

{{#issue.fixVersions}}name: {{name}}{{^last}}, {{/}}{ {/}}

I also tried this, but I only get the last version in my query.

{{issue.fixVersions.name.join("\n• ")}}

Any ideas?

All comments

Kalyan Sattaluri_iinm1n

Hello @Hunter1428

Please try {{issues.fixVersions.name.distinct}}

BTW - Make sure you have below checkbox selected on your scheduled trigger page..

Hunter1428

Hi @Kalyan Sattaluri

Thanks for assisting!

I tried what you suggested but unfortunately this produces.

[], [], [], [], [], [], [], [], [], [], [], [], [], [], [], []

I also tried both below but they produced a blank output.

{{#issues.fixVersions.distinct}} {{name}} {{/}}
{{#issues.fixVersions}} {{name.distinct}} {{/}}

Kalyan Sattaluri_iinm1n

Please log below 2 smart values in the below order (as shown below) and share similar screenshot which shows your audit log.

{{issues.fixVersions.name.distinct}}
{{issues.fixVersions}}

Also, make sure you have checked the box as mentioned in my original post.

BTW - The other smart values you have listed are not correct syntax so blank is expected.

Hunter1428

I copied yours to see if it was some issue with the branch. But still have the same issue.
Double checked and check box "trigger in bulk" is indeed checked.

Hunter1428

Hello again!

So we finally moved to our new data centre and are now on version v9.12.7.

All the options you have given work so thank you for the help on these!

Quick question:
What would be the best way to put each value onto a new line or in a table format?

Tying to create a report like this within an email.

Released on 15th Dec - Version 1
Released on 18 Dec - Version 2
Released on 27 Dec - Version 3

I tried to generate a simple list but this keeps returning blank.

{{#issue.fixVersions}}name: {{name}}{{^last}}, {{/}}{ {/}}

I also tried this, but I only get the last version in my query.

{{issue.fixVersions.name.join("\n• ")}}

Any ideas?

Bill Sheboy

Hi @Hunter1428

As a reminder, I am using Jira Cloud, and not Data Center version, so please test any suggestions to confirm they work.

Just to confirm is this for a single issue as you are showing a prefix of {{issue... for the expressions?

First, try writing just the field to the log and observe what you get:

#1) just the version ids: {{issue.fixVersions}}

That should list the version ids as a CSV list. If that works, try this one:

#2) just the version names: {{issue.fixVersions.name}}

If that works, try this one to iterate the values:

#3) version names iterated over: {{#issue.fixVersions.name}}{{.}}{{^last}}, {{/}}{{/}}

If it works, try adding your formatting.

Kind regards,
Bill

Hunter1428

Hi Bill, thank you for the swift response!

My filter looks over many issues which are spread across multiple fix versions. Can confirm 4 fix versions are spread over the issues the filter finds.

I tried all the suggestions you said and here is the outcome.

Gave me the ID of 1 fix version (Most recent created)
Gave me the name of 1 fix version (Most recent created)
Same as point 2.

If I change issue to issues. I get the full list. But its just one long string which I'm unable to format into bullet points. Maybe I'm just dumb and expecting the "list" stuff to outcome something different then what it actually does.

Here is my automation layout just encase it's an issue with it.

Bill Sheboy

The rule trigger you show has selected the bulk handling option, and so the smart value is the {{issues}} one used, and not {{issue}} and so I wonder if there is something different for that list of values (similar to the current Data Center limitations with Lookup Issues).

Again, I am using Cloud not Data Center, and so cannot check this...

Please try writing this to the log and test the rule:

List of counts: {{#issues}}{{key}}:{{fixVersions.size|0}}, {{/}}

That should produce a list of the keys and the number of fix versions in each issues.

Welcome!

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

Quick Links

Find more posts tagged with

jira

automation

data-center

fix-version

jira-software-data-center