How to return distinct Project names in an automated email rule?

Question

I am using the template automation rule "When a task is near due -> send an email reminder". I would like the email to display the tasks underneath the Project name they are associated with. I am able to list the tasks and the project name in the email body using the {{#lookupIssues}} smart value, but I would like it to display as follows:

Project #1:

Task #1

Task #2

Project #2:

Task #1

Task #2

What I have in the screenshot above displays like this in email:

I haven't been able to find any documentation showing you can use distinct with a Project smart value, but I may have just been using the wrong syntax.

Is there any way to do this?

Daniel Salisbury · Answer

Thank you for the reply, but unfortunately that is not exactly what I'm looking for.

The rule I have is producing a list of the issues pulled from the JQL Query using {{#lookupIssues}}. This iterates each issue and displays it in the email. In my second screenshot it shows what happens if I just put {{project.name}} in the iterated list, it will display the project name above every issue, even if multiple issues are in the same project.

Is there any way to have the list display issues that share a project under one project name?

Mohanraj Thangamuthu · Answer

Hello, Good day. You can explore the following smart value