LookupIssues email sending issues to reporters that aren't relevant to them

[Precious Declan]

Hi all,

Thanks in advance for your help!

I have created a rule to send out emails to the reports notifying them of an issue due to expire. 

I have used To: {{lookupIssues.reporter.emailAddress}} and it sends all issues affected even those not relevant to the reporter.

I have tried {{lookupIssues.reporter.emailAddress.distinct}} which doesn't work.

Another option is to not use lookupissues, and use scheduled trigger JQL, but that sends multiple emails for all issues to the right reporter but i want the list of issues email to be sent out once and be included in a table in the email body.

Is there away I can keep the issues in one email in a table but only including the reporters affected.

[Mark Segall · Accepted solution]

Hi @Precious Declan and welcome to the community:

This one is a tricky one, but it is possible. The key is that you need to perform a branch on {{lookupIssues.reporter.distinct}} and then execute a second lookup inside the branch.

Here's an example of one that I've used successfully previously:

[Precious Declan]

Hi @Mark Segall

Thank you so much this has worked great.

I did have to add my first lookup issues JQL into the branch lookupIssues to get the correct output. 

Thank you again!