Rule to send weekly report with the upcoming weeks tasks and sub-task that are due

[Kaminel]

Trying to create a rule to do the following:

Send a weekly email update every Friday at 4:00pm Mountain with the project summary, a list of all tasks and sub-tasks due the following week, and a list of all tasks and sub-tasks completed during the current week.

Here is what I have so far, but its only pulling completed tasks.

Thank you in advance for the help.

Kami

[Bill Sheboy]

Hi @Kaminel -- Welcome to the Atlassian Community!

For a question like this, please also post an image of the audit log details showing the rule execution.  That may provide more context for this syptom.

Until we see that...

If you try the JQL for your first lookup to find tasks due next week, does it return any issues?  And, are all of those issues in one Jira project?

Please also post image of the create variable actions and the body of the email your rule sends, as those may indicate a mismatch between the data and result output.

Kind regards,
Bill

[Jovin]

Hey @Kaminel 

Have you tried creating filters and saving them, then setting up a subscription for them to run at that time instead of using automation?

https://support.atlassian.com/jira-software-cloud/docs/manage-filters/#Subscribe-to-a-filter

[Kaminel]

I don't want 2 reports, I want one report with project summary page and a list of all issues completed during the current week and all issues due the following week.