Can I automate the creation and export of a report to then email weekly?

[Brad Smith]

For context:

I am looking to create and email 2 reports.

One will be a weekly report showing issues updated within that week. I would like all the info to be present with the report

(Summary, key, issue type, priority, creator, assignee, created and updated)

This then would be emailed.

A seperate automation, would be a report showing all issues resolved in that week. Same info as above. and emailed

[Dirk Ronsmans · Accepted solution]

Hi @Brad Smith ,

In my mind you got 2 options to do this.

1) you can leverage the Automation engine to perform a scheduled action (based on a Cron job) which will do a JQL query. This query (using lookupIssues) can then be translated in to an email with the "Send Email" action (of Automation)

https://community.atlassian.com/t5/Automation-articles/New-lookup-issues-fields/ba-p/1873978

2) A bit less flexible but easier to set up would be to use filters and subscribe to those. By subscribing to the filter you would get a weekly email with the information you requested based on a standard template.

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4

[Brad Smith]

I went with #2, works great thank you

[John Funk]

Hi Brad - Welcome to the Atlassian Community!

You can create two different filters that show the information you want. 

Then create a Subscription for each filter to send an email based on the timing of the subscription. 

Here is a block article to help guide you. 

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4

[Brad Smith]

Thank you, it works great!