nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can Jira Automation be used to send users a list of issues that are due in the next N days?

Elvar Böðvarsson

I'm using an automation job to search for issues that are overdue and send reminder emails to the assignee.

What I want to do now is send a similar email on Mondays with a list of issues that are due that week.

Can Jira Automation be used for this or is the only solution to create an issue filter and tell people to subscribe to it?

Accepted answers

Tom Williams_z640l2

Yes this can be done using Jira Automation.

Set the automation on a schedule using a Cron Expression, then use the action "Lookup Issues" provide the JQL to return the issues due that week.

Then add the "send email" action and include the following in the email body to print out a list of the issues;

{{#lookupIssues}}
* {{key}} | {{summary}} [.....etc]
{{/}}

Where key, summary can be replaced or added to with these smart values, (custom fields in the future hopefully)

{{key}} - Returns the issue key
{{url}} - Returns the issue url
{{summary}} - Returns the issue summary
{{assignee.displayName}} - Returns the assignee
{{reporter.displayName}} - Returns the reporter
{{status}} - Returns the status
{{issueType}} - Returns the issue type
{{resolution}} - Returns the resolution status
{{fixVersion}} - Returns the fix version
{{created}} - Returns the date the issue was created
{{updated}} - Returns the date the issue was updated
{{Story Points}} - Returns the story points for the issue (classic Jira Software)
{{Story point estimate}} - Returns the story points for the issue (next-gen Jira Software). Learn more about using smart values with numbers.

Source: https://support.atlassian.com/jira-core-cloud/docs/automation-actions/

All comments

KAGITHALA BABU ANVESH_z1zl10

Hello,

Please try this once.

Every Monday 8.15 AM. assignee will notified with Due Date.

Cron+ JQL

New Action

Hey sorry , I thought it's for a week.

Thanks.

Tom Williams_z640l2

Yes this can be done using Jira Automation.

Set the automation on a schedule using a Cron Expression, then use the action "Lookup Issues" provide the JQL to return the issues due that week.

Then add the "send email" action and include the following in the email body to print out a list of the issues;

{{#lookupIssues}}
* {{key}} | {{summary}} [.....etc]
{{/}}

Where key, summary can be replaced or added to with these smart values, (custom fields in the future hopefully)

{{key}} - Returns the issue key
{{url}} - Returns the issue url
{{summary}} - Returns the issue summary
{{assignee.displayName}} - Returns the assignee
{{reporter.displayName}} - Returns the reporter
{{status}} - Returns the status
{{issueType}} - Returns the issue type
{{resolution}} - Returns the resolution status
{{fixVersion}} - Returns the fix version
{{created}} - Returns the date the issue was created
{{updated}} - Returns the date the issue was updated
{{Story Points}} - Returns the story points for the issue (classic Jira Software)
{{Story point estimate}} - Returns the story points for the issue (next-gen Jira Software). Learn more about using smart values with numbers.

Source: https://support.atlassian.com/jira-core-cloud/docs/automation-actions/

Tom Williams_z640l2

This works but sends an individual email for each issue returned in the JQL. My solution below returns a list that could be sent in a single email.

KAGITHALA BABU ANVESH_z1zl10

Hi Tom,

Thanks for the information.

Bill Sheboy

Hi @Elvar Böðvarsson

You may also send a single email with the upcoming due items by creating a saved/shared filter and then subscribing to it. People who want the email can subscribe (for shared filters.)

Please see here to learn more about this feature:

https://support.atlassian.com/jira-core-cloud/docs/work-with-search-results/

Best regards,

Bill

Elvar Böðvarsson

Can this be used in a way that each assignee only gets sent their issues?

Tom Williams_z640l2

If you're just running this for your scrum team or a small group perhaps you could just sort the JQL by the assignee and include {{assignee.displayName}} in the email so each person's tickets are grouped together and visible in the list.

OR// If you have a small number of assignee's that don't change often you could include the assignee in the JQL and create a separate rule for each person.

HOWEVER// If the group of assignees is large and always changing, which would make this a nightmare to maintain I'd suggest going with @KAGITHALA BABU ANVESH 's solution but they'd end up with an email for each.

Elvar Böðvarsson

As the people needing the notification are a few I defined the emails specifically in the automation configuration.

I tried to have the assignee as the recipient but that did not work because in the initial trigger there is no JQL query and the assignee value is from that query. Not from the look up issue filter.

Works for now, thanks for the information.

Elvar Böðvarsson

I know about this feature and prefer not to use it as it just sends a dull list of issues. Much prefer Automation as with that I can include custom text.

Now if it were possible to combine those two have filters which people could subscribe to at will and that the email sent would be customizable by the filter owner

Bill Sheboy

Here are some suggestions to improve subscription emails, which you may watch or vote for:

https://jira.atlassian.com/issues/?jql=project%20IN%20(JRACLOUD%2C%20JSWCLOUD)%20AND%20resolution%20%3D%20Unresolved%20AND%20summary%20~%20subscription%20AND%20summary%20~%20email%20ORDER%20BY%20Key

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-cloud

automation