Comparison within a field followed by a comparison to another field

[Sven Meier]

Dear Community,

Could someone please help me with the automation I try to build?

There are several steps I need help with.

1. Comparison of values within a field. We have a customized field called "ICE Task". We can put in multiple ICE Tasks within that field. Now, I would like to compare the values of that field to be specific {{triggerIssue.customfield_10104.RELEASE}}. Would that be even possible? (The information you get from that look like: LG57_24.09.00)

2. Comparison between different fields: If 1. is possible I would like to compare the lowest release with another field called "Avaloq Release", to be specific again {{issue.customfield_10103.Name}}. The information you get from that looks like: 24.09.00

3. If 1. and 2. is possible I would like to have different actions depending of the result of the comparison.

3.1. If 2. is true then create an approval and transition work item status

3.2. If 2. is false then send an email and do not transition work item status.

I was able to make a comparison between "ICE Task" and "Avaloq Release". That looks like this: it is a smart value condition

- First Value: {{triggerIssue.customfield_10104.RELEASE}} (= ICE Task)

- Condition: contains

- Second Value: {{issue.customfield_10103.Name}} (= Avaloq Release)

Any help or tip is encouraged and greatly appreciated.

Sven

[Bill Sheboy]

Hi @Sven Meier 

What you describe is possible using text functions to extract the date from the field and then converting that with toDate, and then performing the comparisons.  And if there are a list of date values, those could be examined using the list min function to find the smallest one.

Here are some documentation references to you help you do this:

• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/
• https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Converting-text-to-dates
• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#list.min

If you encounter further challenges, please provide more context by posting:

• what version of Jira are you using: Cloud, Server, or Data Center
• an image of your complete rule
• an image of the audit log details showing the rule execution
• explain what is not working as expected, and why you believe that to be the case

Kind regards,
Bill