I would like to create an automated report for all JIRAs raised in a project.
It will run monthly (the first of each month) and send an Excel spreadsheet by email.
Is this possible?
Hi Bhanu Prasad,
You can create a filter and subcribe to it.
https://confluence.atlassian.com/display/JIRA/Receiving+Search+Results+via+Email#ReceivingSearchResultsviaEmail-SubscribingtoaFilter
Bhushan, it worked for me. thankyou!!
Please accept the answer if it worked. Thank you.
Hi Bhanu,
If you need more complex reports including logged time, linked issues and more you should check out our plugin Intelligent Reports. You can design your report template in Microsoft Word, fill it in with simple point and click rules including multiple JQL queries, charts and more, and then schedule it to be sent to you by email.
With Excel Automation for JIRA you can generate Excel spreadsheets periodically or at issue events (when an issue created, updated, transitioned, etc.). The spreadsheets are generated from Excel templates that are regular Excel files themselves, and allow using:
See the Excel tutorial
jira-automatic-excel.png
Is there a way to make Jira send you the CSV/excel version of the query (rather than a link to the online query)?
Does it work for cloud version of JIRA?
This does not send reports in email. This sends a single website link.
Both Intelligent Reports and Excel Automation for JIRA appear to be for server clients only. If anyone knows of an integration that does this for cloud, please let us know!
Why cant I see any answers here?
I use Jira v8.4.2 and I get the content of the filter (e.g. the list of issues with assignee, etc.) in addition to the link. Not sure if it was customized somehow but it does the job for me.
Is there a way to automate reports for Cloud version?
It looks like you're new here. Sign in or register to get started.
