Getting a filtered subset of a lookupIssues smartvalue or multiple lookupIssues's

Jonathan Aspeling_20pcvh

Good day all, 

 

What I'm doing:

Getting JQL results that get's stored as a lookupIssues smartvalue.

I reference the lookupIssues in a HTML Mail Template. 

I get a count of the items in the lookupIssues variable by going {{lookupIssues.size}} to use in the mail to indicate x amount of issues present.

What I would like to do

Filter the lookupIssues based on status of issues in the object. So that I can return two different counts based on the filter. 

Something like {{lookupIssues.size}}{{where status = 'Pending Customer Approval'}}

 

Bill Sheboy

Hi @Jonathan Aspeling 

How about this approach:

1. Lookup Issues on one of the counts you need with JQL
2. Save the count {{lookupIssues.size|0}} in a Created Variable
3. Repeat steps 1-2 for as many counts as you need
4. Create your email, referencing the created variables

If you need the specific details for each lookup in the email, now it gets fancier:

• Once you have a lookup, iterate over the values to build the HTML for the email using text functions, and storing the result in a Created Variable
• Repeat...
• Build your email, using the pre-built HTML snippets

Best regards,

Bill