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; } } }

How to create Automation email only showing Assignee issues

Richard Tjong

Hi all!

I´m trying to create an automation where an email is sent to assignees and only showing the assignees issues, not anyone elses. At the moment, the automation will run a JQL search, if the search matches assignee, it proceeds to send emails to those assignees. However it will list every issue found from the JQL.

Is there a smartvalue or automation component which I can include to show only the email recipients issues in the email?

Trigger: Scheduled JQL search

Then: Lookup issues using JQL

If matches: Assignee

Then send Email (below)

Hi {{issue.assignee.displayName}}
Due date for your assigned issues in the project is approaching in the next 7 days.
Please update the progress of your issue.
List of issues:

Issue Key: {{key}} (<a>{{url}}</a>)
Summary: <a>{{Summary}}</a>
Assignee: <a>{{assignee.displayName}}</a>

Thanks in advance!

Accepted answers

Rilwan Ahmed

Hi @Richard Tjong ,

Please follow below steps

1. Navigate to Filters -> Advanced issue search

2. Use the following JQL search clause (if the due date is due in 7day);

assignee = currentUser() AND resolution is EMPTY AND duedate = 7d

3. Click 'Save as' to save the filter

4. On the same page, click on 'Details' right next to 'Save as' and click on 'New subscription' and then configure how often you want the notification to be sent to you.

When you select "Personal Subscription", only you will receive the emails
You can select the group and it will send email to each user and only their tickets in the email

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4
https://confluence.atlassian.com/jira064/receiving-search-results-via-email-720416706.html

Bill Sheboy

Hi @Richard Tjong

Would you please clarify your scenario, as that may help the community to offer suggestions?

For example, are you trying to:

For one specific assignee (e.g., always the same user) run the scheduled rule to send their issues list
For any issue found which are coming, send to each individual user their list of issues

Scenario #1 can be handled by changing the JQL of the lookup to only reference the specific user.

Scenario #2 can be handled using a generic lookup for upcoming issues, which is then parsed to send each email with an advanced branch.

Kind regards,
Bill

All comments

Rilwan Ahmed

Hi @Richard Tjong ,

Please follow below steps

1. Navigate to Filters -> Advanced issue search

2. Use the following JQL search clause (if the due date is due in 7day);

assignee = currentUser() AND resolution is EMPTY AND duedate = 7d

3. Click 'Save as' to save the filter

4. On the same page, click on 'Details' right next to 'Save as' and click on 'New subscription' and then configure how often you want the notification to be sent to you.

When you select "Personal Subscription", only you will receive the emails
You can select the group and it will send email to each user and only their tickets in the email

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4
https://confluence.atlassian.com/jira064/receiving-search-results-via-email-720416706.html

Bill Sheboy

Hi @Richard Tjong

Would you please clarify your scenario, as that may help the community to offer suggestions?

For example, are you trying to:

For one specific assignee (e.g., always the same user) run the scheduled rule to send their issues list
For any issue found which are coming, send to each individual user their list of issues

Scenario #1 can be handled by changing the JQL of the lookup to only reference the specific user.

Scenario #2 can be handled using a generic lookup for upcoming issues, which is then parsed to send each email with an advanced branch.

Kind regards,
Bill

Richard Tjong

Hi Rilwan!

This worked perfectly, thank you! Managed to assign all the groups recurring filter subscriptions. Now each assignee will recieve a list of their current issues with due dates within 7 days on a weekly basis.

Richard Tjong

Hi Bill!

Scenario number 2 is what I was looking for. I wanted to send an automated email with a list of all the issues of the email recipients (assignees), within a timeframe. Tried to solve it with Automation however we had too many project members to create branching actions, and the list smart value showed all issues and not assignee specific.

However, managed to solve this with Filter subscriptions and JQL which returns the current logged in user. This solution works great!

Thank you for suggestion your solution!

Bill Sheboy

Hi, Richard.

I am glad to learn you solved this with filter subscriptions.

FYI for what I was suggesting, I did not mean to create a branch for each person, as that could be a very long rule! Instead you can use the lookup to drive the branch, like this:

trigger: scheduled with no JQL
action: lookup issues, with the JQL, to find the issues of note
advanced compare condition: to check for issues with {{lookupIssues.size|0}} is greater than 0
advanced branch: over the possible assignees. The key is using distinct to walk the users/people who have assigned issues.
- variable: varAssigneeAccountId
- smart value: {{lookupIssues.assignee.accountId.distinct}}
  - action: lookup issues again with the JQL, adding on assignee = {{varAssigneeAccountId}}
  - action: send your email to the specific person/user

Kind regards,
Bill

Richard Tjong

Hi Bill,

I tried this out, in one of the last steps I couldnt add a smart value {{varAssignee.accountId}} to the JQL. What would the JQL be for this smartvalue?

trigger: scheduled with no JQL
action: lookup issues, with the JQL, to find the issues of note
advanced compare condition: to check for issues with {{lookupIssues.size|0}} is greater than 0
advanced branch: over the possible assignees. The key is using distinct to walk the users/people who have assigned issues.
- variable: varAssignee
- smart value: {{lookupIssues.assignee.distinct}}
  - action: lookup issues again with the JQL, adding on assignee = {{varAssignee.accountId}}
  - action: send your email to the specific person/user

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud