Jira Automation - Send E-Mail with ALL due tasks

[Lea Beckmann]

Hi there,

We use Jira Automation a lot to remind us of due tasks. I'm facing the problem that we get one email per task and I'd like to get one email with all due tasks in the next week (see JQL).

Does anyone know if this is possible and how?

JQL: project = "x" AND assignee = xx AND due < endOfWeek("+1") AND NOT status="done"

email-text:

Dear x, this is your reminder that your task ( {{issue.summary}} ) is due on {{issue.duedate}}. Here is the link to your task: {{issue.url}}

Thanks a lot!

[John Funk · Accepted solution]

Hi Lea,

You will need to use the lookupIssues functionality. Take a look at this previous post for guidance. 

https://community.atlassian.com/t5/Jira-questions/Smart-Values-not-working-as-expected-creator-displayName-and/qaq-p/2679352

[Lea Beckmann]

That sounds good - I tried it but it didn't really work, seems like I'm missing a step (or two):

1. Trigger (every Friday)

2. then: Lookup Issue -> project = "x" AND assignee = xx AND due < endOfWeek("+1") AND NOT status="done"

3. and: send email: Dear x, this is your reminder that your task {{lookupIssues.first.assignee.displayName}} is due on {{issue.duedate}}. Here is the link to your task: {{issue.url}}

Questions:

My second step finds every due task but it's not displayed in my sent email and what shall I enter in the bold marked variables?

[John Funk]

Can you share a screenshot of the actual rule?

[Lea Beckmann]

(For security reasons, I have changed the email address)

[John Funk]

Can you share the details of the Send Email action? (The last step)

[Lea Beckmann]

Sure 

[Lea Beckmann]

I figured it out, the final mail looks like this:

Dear X,

This is your reminder that the following tasks are due next week:

{{#lookupIssues}}
- {{summary}} ({{url}})
{{/}}

[Jan Graeber]

Just stumbled over this: 

Is the JQL working?

Last bit looks wrong to me, should be:

"AND status not in (done)"

[Lea Beckmann]

yes, it works - I use it for a couple of automations