Automated Rule to send an issue report of aging ticket on mail

[Georgeta Pojoga]

Hi,

I would like to collect a report with aging old issues and send it on mail to a developer. 

The JQL of the issues: project = ITS AND created < -14d AND status = open 

I've tried to collect the result of this query and send an unique report of this issues (for example: "Hi, here are the aging tickets remained open: ISSUE 1, ISSUE 2, ISSUE 3 ecc.." 

But the rule sends a mail per issue, means that if the result of the query is 26 issues I receive 26 different mail per every issue! 

Is there any way to collect this issues in a unique list and send it email? 

[John Funk · Accepted solution]

Hi Georgeta - Welcome to the Atlassian Community!

I would suggest you set up a Subscription to your filter and send that each day (or however often you want to send it).

See this article and go the section for Subscribe to search results.

[Jack Brickey]

https://support.atlassian.com/jira-software-cloud/docs/save-your-search-as-a-filter/#Savingyoursearchasafilter-Subscribetoafilter 

[Zaldy Parian]

Hi @John Funk ,

Is your suggestion going to send the link of the filter or send a summary report as a body of an email or attachment?

I have been trying to find an automation to send end-of-day summary report for non-Jira project team members (e.g., our boss or 3rd party SI).

Regads,

Zaldy

[John Funk]

@Zaldy Parian  - Using a subscription to a filter will show a few rows of the results but then a link to the full list. Parties without access to your Jira will not see the full list. 
The other option is to create an Automation for Jira rule that sends emails which can show each issue in the list. You would list as many fields/columns as you want to create in the email - it won't send an actual filter itself.