Queries within a Lookup

Russell Brown_lmjbx7

I want to be able to do a lookup and then, within that lookup, run logic to show only selected items.

 

Use Case:

Release Notes or Documentation - Break down sections of an email by business group or project and auto-send the email when the sprint is closed.

 

---

 <h2>Sales Items</h2>

{{#lookupIssues}}

{{if(equals(issue.businessunit, sales))}}  

<hr style="margin: 20px 0">
{{customfield_11407}}</br>
<em style ="font-size:12px;">{{issueType.name}} <b>{{key}}</b> | <span style="color:#00669e">{{customfield_11288}}</span> Deployed: {{Resolved.shortdate}}</em>

{{/}}

{{/}}

 <h2>Service Items</h2>

{{#lookupIssues}}

{{if(equals(issue.businessunit, service))}}  

<hr style="margin: 20px 0">
{{customfield_11407}}</br>
<em style ="font-size:12px;">{{issueType.name}} <b>{{key}}</b> | <span style="color:#00669e">{{customfield_11288}}</span> Deployed: {{Resolved.shortdate}}</em>

{{/}}

 

 <h2>IT Items</h2>

{{#lookupIssues}}

{{if(equals(issue.businessunit, it))}}  

<hr style="margin: 20px 0">
{{customfield_11407}}</br>
<em style ="font-size:12px;">{{issueType.name}} <b>{{key}}</b> | <span style="color:#00669e">{{customfield_11288}}</span> Deployed: {{Resolved.shortdate}}</em>

{{/}}

{{/}}

Bill Sheboy

Hi @Russell Brown 

What is not working as you expect?

Please note when using {{lookupIssues}} with an iterator, you refer to the fields without an issue prefix, such as with:

{{#lookupIssues}}
  {{key}} - {{summary}}
{{/}}

When you use {{issue.somefield}} inside of the iterator, it is instead referring to an issue outside of the lookup issues iterator.

Kind regards,
Bill