Reference 2 Lookup Issues action list in one rule

[Nofar Ben Kereth]

Hey,

Is it possible to reference 2 different Lookup Issues list in one rule? 

I would like to lookup for 2 lists and divide the size of them by each other. 

Thanks,

Nofar

[Bill Sheboy · Accepted solution]

Hi @Nofar Ben Kereth 

No, and...You could store the results such as count (size) in a created variable and use it later once you use Lookup Issues again for the second query.

Best regards,
Bill

[Nofar Ben Kereth]

That's what I did but it doesn't seem to work. Adding screenshots 

[Bill Sheboy]

Would you please show what you set as the value for your created variable?  Thanks!

You cannot save the entire {{lookupIssues}} result in a created variable... Although I wonder if it was converted to JSON if that was possible.  Anyways... You can save the count as that is what you wanted for the division:

{{lookupIssues.size|0}}

Note that I added the default value of zero.  That makes it easier to check before trying to divide by zero (or null) later.

And...please note that smart values and functions are case-sensitive, so your division value appears to have the incorrect capitalization for the smart values.

[Nofar Ben Kereth]

Thanks Bill.

Actually I had a problem with the case sensitive smartvalues. 

But I still don't get the right answer. 

I get the value of the second list size and not the answer to the division of the 2. 

My variable is simple as {{lookupIssues}} (will add the |0, thanks for the tip :))

[Bill Sheboy]

Gotcha; you need to save just the size, not the entire {{lookupIssues}}

[Nofar Ben Kereth]

Apparently this is what I did, the final number I ger is still the size of the 2nd list. Any idea? 

[Bill Sheboy]

Okay, two things to help/try:

• At each point where you think you have a value, also use the action to write that to the audit log.  That should confirm if the first lookup issues has any data.
• Next...and sorry I forgot this: created variables cannot be used as parameters to functions.  So the work-around is to use a math expression and to convert the variable to a number, when editing Epic Progress:

{{#=}}{{lookupIssues.size|0}} / {{IssuesInEpic.asNumber}}{{/}}

You may want to tweak it to get the precision/number of digits you want.  

[Nofar Ben Kereth]

Thanks! That helped!!