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.

[Tauwa · Accepted solution]

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. 

[Tauwa]

[Barış Özer]

First of all, thank you very much.

In the screenshot you took about Automation;

An e-mail will be sent to the assigne person 7 days before the due date.

1 day after the due date, an e-mail will be sent to the e-mail address I want, is it true?

Does the JQL you wrote work for this?

[Barış Özer]

Can you share the rule details with a step-by-step screenshot?

If:matches then I can't find what to do.

[Barış Özer]

@Tauwa 

I did as you showed.

7 days ago the notification will go and after 1 day the notification will be gone, is it true?

[Tauwa]

Yes it is OK. Don't forget to accept the answer plz. 

cheers

[Barış Özer]

@Tauwa 

I fixed the JQL code as below;

(due < 7d and due >=now()) OR (due > -1d)

Is it correct?

regards

[Barış Özer]

@Tauwa 

(due < 7d and due >=now()) OR (due > -1d)

It started working correctly with this code.
But there is no ticket number in the content of the e-mail. How can we write?

Thx

[Tauwa]

use smart values : https://support.atlassian.com/cloud-automation/docs/what-are-smart-values/

[Barış Özer]

@Tauwa 

Where exactly do I need to write the smart value? To the content of the mail?

Can you post a screenshot example please?

[Barış Özer]

@Tauwa 

I did it with issuekey,
Can we put the related issue as a link?

[Barış Özer]

@Tauwa 

I did it, thanks a lot for your support (:

Best regards.

[Tauwa]

Great. You are an Automation Pro now :) 

[Barış Özer]

@Tauwa 

Hello again,

Although there is a due date of August 1, the mail notification is gone.

Since the ticket has passed for 1 day, can you help me where am I doing wrong?

[Tauwa]

due < -1d NOT due > -1d

[Barış Özer]

@Tauwa Hi,

(due < 7d and due >=now()) due < -1d NOT due > -1d

I don't understand what exactly to change?

Can you write the full version please

[Barış Özer]

Hi @Tauwa 

If matches: I changed the part.
Is it correct ?

[Rajesh Ramankutty · Accepted solution]

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?