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

Automation distinct and formatted

Mark Segall_iqztfr

Hey there community,

I'm trying to set up a rule that is getting quite complex and hoping someone here can help me out. Here's what I have so far in the rule:

I have a look up issues action that pulls in all blocked issues
I have a variable (varMyVariable) that gives me the Insight object attribute off of each of the blocked issues which is always numeric. The variable looks like this:
- ```
{{lookupIssues.customfield_xxxxx."My ID"}}  
```
The results look something like this:
- [123], [234], [345], [234], [789], [321], [1], [1], [10], [45], [654], [555],[54], [222], [777]

So far so good... Now I have some formatting requirements that seem to be eluding me. The final result should look like this:

[123|234|345|789|321|1|10|45|654|555
54|222|777]

There are three requirements coming into play:

Result should be pipe delimited - I've successfully accomplished this with a new variable:
1. ```
{{varMyVariable.replace("], [","|")}}
```
Result needs to be distinct - I've failed every way I've tried this. I've tried the following:
1. ```
{{varMyVariable.distinct}}
```
2. ```
{{lookupIssues.customfield_xxxxx."My ID".distinct}}
```
Result needs to split to a new line after every 10 matches

Appreciate any insights for this.

Accepted answers

Garrett McCreery

Hi Mark,

The distinct part...

The first attempt

```
{{varMyVariable.distinct}}
```
This is not working because once you create a smart value-variable in Jira automation it turns it into a string, so it's not an array anymore, there for distinct will not work.
```
{{lookupIssues.customfield_xxxxx."My ID".distinct}}
```
What value did you get when this was run? This seems to be the correct syntax.

All comments

Garrett McCreery

Hi Mark,

The distinct part...

The first attempt

```
{{varMyVariable.distinct}}
```
This is not working because once you create a smart value-variable in Jira automation it turns it into a string, so it's not an array anymore, there for distinct will not work.
```
{{lookupIssues.customfield_xxxxx."My ID".distinct}}
```
What value did you get when this was run? This seems to be the correct syntax.

Mark Segall_iqztfr

Thank you for the quick response @Garrett McCreery

It still returns all values. Here are the results of my sample issue where I'm still using distinct against the lookupIssues result (I've highlighted the dupes in bold):

[4068], [11909], [3594], [4517], [4248], [13452], [1908], [3883], [1], [1], [1], [1], [10], [10000], [10123], [10321], [10432], [10543], [10654], [10765], [10876], [10123], [10123], [10789], [10], [1], [1], [1]

Spent a couple hours on this one yesterday and just can't seem to get this one to play nice.

Garrett McCreery

@Mark Segall

ok, I figured out how you can do this...

Take your result variable, and split it by commas with the distinct function...

insightObjectIDs.split(",").distinct

Then you can use the replace method to get it back to the pipe separator.

Garrett McCreery

The split function turns it into an array (or "list") where the distinct function can be run!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud