Iterating through elements in a generated smart values list

[Dd]

Hi,

Say I generated a smart value list from a JQL ListOfNames which is {{lookupissues.MyNames.distinct}}.

How can I now iterate over this list using a smart value SomeName and use that value each time in a JQL query?

Thanks

[Kian Stack Mumo Systems · Accepted solution]

@Dd

I'm not seeing a great way to do this. What are you trying to accomplish?

Thanks,

Kian

[Dd]

What I'm trying to achieve is as follows:

Say I have open tickets that can be related to CARs. Cars is a Custom field and I have different models.

I would like automation to run a JQL of all the open tickets.

Go through the lookup list and pickup all the distinct car models in open tickets.

Then loop over the list of distinct models.

For each:

• Run a JQL and get a lookup list of all the open tickets for that model.
• If the size of the list is over a predefined number - send an email

Does that make it clearer?

Thanks    

[Kian Stack Mumo Systems]

Thanks @Dd

I was able to get something to work!

The general configuration looks like this:

1. Perform the lookup
2. Do an "Advanced branching" with the smart value set to "{{lookupIssues.cars.value.join(",").remove("[").remove("]").replace(", ",",").split(",").distinct}}" and the variable name set to Cars
3. Perform a lookup of issues with the JQL cars in ({{car}})
4. Write an advanced If condition. {{lookupIssues.size}} > [YOUR CUTOFF]
5. Send the email!
   

[Dd]

This looks awesome. I'll try it!

Question though - I assume (based on what you wrote) that there's a way to see the actual output of a smart value. Where can I read how to do that?

Thanks

[Dd]

I'm probably doing something wrong as my JQL fails

I probably don't use the smart values properly.
I'll try Sunday, and if it fails - I'll upload my attempt

[Dd]

I'm doing something wrong. To be honest, I'm not sure what cars refers to in your example.
In any case, below is a snapshot of what I wrote 

I also had a version with a JQL

th don't work (the JQL won't even be verified).
Obviously I'm doing something wrong :-(

[Kian Stack Mumo Systems]

"Cars" was just a custom field I created to have the different car models!

[Dd]

I figured that one out eventually :-)
But as u can see above - I can't get that to work. 

Any ideas?

[Kian Stack Mumo Systems]

What is the value in your smart value {{failedBranch}}?

[Dd]

I cannot see it.
I tried using the add log with {{#debug}} in front and it wouldn't accept that

[Kian Stack Mumo Systems]

Add a new action of the type "Log Action". Add the smart value in there and rerun your rule.

[Dd]

I did, and it failed - I'll try again

[Kian Stack Mumo Systems]

That is expected! You need to go into the audit log and see what was logged.

[Dd]

It just logs {{FailedBranch}} with no content.
Should I plug in the {{#debug}} in fromn?

[Kian Stack Mumo Systems]

No, that won't do anything. Can you share a screenshot of the branching you are trying to do?

[Dd]

I do get a failure later on 

Custom Smart Value JQL Search: "("Failed in Branch[Dropdown]" in ()) AND (project in (10002))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 35)

in () looks like the {{FailedBranch}} is empty 

[Dd]

{{lookupIssues."Failed in Branch[Dropdown]".value.join(",").remove("[").remove("]").replace(", ",",").split(",").distinct}}

[Kian Stack Mumo Systems]

Is the actual field called "Failed in Branch[Dropdown]"? Or is Dropdown the type?

[Dd]

Dropdown is indeed the type but that's the way it appears in the JQL.
I have it in an initial JQL and it works fine with that Dropdown

At the start I'm executing "Failed in Branch[Dropdown]" is not EMPTY and I get the correct lookup list

[Kian Stack Mumo Systems]

Get rid of it in the smart value. Try it like this -

{{lookupIssues.Failed in Branch.value.join(",").remove("[").remove("]").replace(", ",",").split(",").distinct}}

[Dd]

OK.
That made some progress.
Let me try and play with it tonite and see if I get anywhere.
I'll update tomorrow.
Thanks

[Dd]

So now I get the correct list in FailedBranch. (BRANCH_2)
How do I loop over the values in FailedBranch and for each run the JQL filtered to that value and then check the size?
 
Doesn't seem like "Failed in Branch[Dropdown]" in ({{FailedBranch}}) does the trick

[Dd]

I figured out what I did wrong - it's working!
Thanks

[Kian Stack Mumo Systems]

Excellent! What was the issue?

[Dd]

Once you resolved the issue of getting the log action to work, I could see the actual parameter extracted from the list. Then it was clear I was missing quotation marks on the value when filtering since I had a space in it.
 

Now it works perfect!

[Dd]

I'll ask one last semi-related question - when I send the email - is there a way to send the issues from the lookupissues list as hyperlinks and not just ticket keys?

[Kian Stack Mumo Systems]

Put this in the body of the email:

{{#lookupIssues}}
{{url}}
{{/}}

[Dd]

Worked like charm!
Thanks