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
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
That's what I did but it doesn't seem to work. Adding screenshots
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gotcha; you need to save just the size, not the entire {{lookupIssues}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Apparently this is what I did, the final number I ger is still the size of the 2nd list. Any idea?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Okay, two things to help/try:
{{#=}}{{lookupIssues.size|0}} / {{IssuesInEpic.asNumber}}{{/}}
You may want to tweak it to get the precision/number of digits you want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.