JIRA Automation

[mathew Pelchat]

Hello all,

We are trying to use a JIRA automation to assign a "Capability Start Date" to our capabilities based on the first fix version release date of it's linked features. We are utilizing an "implements" and "is implemented by" link type. We have tried several iterations of this automation and have been partially successful. We have gotten the automation to identify the features under the capabilities by the issue link but and to identify the min fix version date using the smart value {{lookupissues.fixVersions.startDate.min}} but cannot get the automation to then pull and assign the date to the capability. I'm not 100% sure that any part of our automation is correct even though it is coming back "successful". Any help would be appreciate on what automation we should use and what syntax will work best for the JQL queries or smart values.  

Mat Pelchat

[Trudy Claspill]

Hello @mathew Pelchat 

Welcome to the Atlassian community.

When asking for help with an Automation Rule, it will enable us to help you better if you provide the following:

1. Screen images showing your entire rule.
2. Screen images showing the details of each step, especially steps where you use smart values or JQL statement.
3. Screen images showing all the details available in the audit log from when the rule executed.

[Bill Sheboy]

Hi @mathew Pelchat -- Welcome to the Atlassian Community!

Without seeing your entire rule, I hypothesize you are using the Lookup Work Items action to gather those linked features, and trying to find the date from there.

Please note the lookup result is a list of work items, and the fixVersions smart value is also a list of versions...leading to a nested list of lists.  When you want the single minimum value for the startDate within all of the version lists, you may use the flatten function to combine all of the results into one list, followed by distinct to remove duplicates, before using the min function:

{{lookupIssues.fixVersions.startDate.flatten.distinct.min}}

Finally, depending upon how you are updating the other field, you may need to add .jiraDate to the end to force the formatting.

Kind regards,
Bill