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

Due Date Automation

Barış Özer

hello everyone,

In a project, we want to send an e-mail to the person assigned to the assignee 7 days before the due date in each ticket. And I want an e-mail to be sent to an e-mail address I want.

1 day after the due date expires, I want to send an e-mail to the assigne and to the e-mail address I want.

Need JQL?

Or can I do it with Automation?

I ask for your help.

Best regards.

Accepted answers

Rajesh Ramankutty

You can write JQL and Add Filter Subscription to it.

Tauwa

Here is the solution:

Filter Subscription:
- Requirement1: 7 days before due date
  - Create a JQL Filter
```
due < 7d and due > now() and assignee = currentUser()
```
  - Create a subscription to all your users but you have to identify the group. You can select a group where all your users are. Don't worry the email will be sent only to the assignee. You can send this on a daily basis for example (or choose what you want)
- Requirement2: 1 day after due date expires
  - Create a JQL Filter
```
due = -1d and assignee = currentUser()
```
  - same as before. Notice though that with filter subscriptions you WILL NOT be able to use a public email address.
Automation: will do the same and even more. Because you will be able to send emails to a public email address

Hope it helps.

All comments

Rajesh Ramankutty

You can write JQL and Add Filter Subscription to it.

Barış Özer

Is it done with automation?

Can you write sample code for JQL please?

Tauwa

Here is the solution:

Filter Subscription:
- Requirement1: 7 days before due date
  - Create a JQL Filter
```
due < 7d and due > now() and assignee = currentUser()
```
  - Create a subscription to all your users but you have to identify the group. You can select a group where all your users are. Don't worry the email will be sent only to the assignee. You can send this on a daily basis for example (or choose what you want)
- Requirement2: 1 day after due date expires
  - Create a JQL Filter
```
due = -1d and assignee = currentUser()
```
  - same as before. Notice though that with filter subscriptions you WILL NOT be able to use a public email address.
Automation: will do the same and even more. Because you will be able to send emails to a public email address