Due Date Automation

[Barış Özer]

Hello my family,

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?

[Sreenivasaraju P · Accepted solution]

Hi @Barış Özer ,

Looks like your JQL is returning wrong results. 

As you have entered due > -1d , it is returning all the requests where due is greater than yesterday. Please correct your query.

[Barış Özer]

Hi @Sreenivasaraju P 

What should be the correct JQL?

due = -1d ?

If you know, can you share the correct JQL code..

[Sreenivasaraju P]

Hi @Barış Özer ,

if you want to get notified for the all the tickets , where due date is greater than -1d and less than 7d. you can use below query.

due < 7d and due >= -1d 

[Barış Özer]

Hi @Sreenivasaraju P 

If: matches 

As you said I changed the part.
Is it correct ?

[Sreenivasaraju P]

Hi @Barış Özer ,

I was referring the below query.

this query returning all the requests where due is greater than yesterday. 

As per you configuration, mails are getting triggered for all the requests. (either in if case or else case)

[Barış Özer]

Hi @Sreenivasaraju P 

Did I understand correctly?
With the following configuration, the mail will be sent 7 days ago and 1 day after the due date, is it true?

[Sreenivasaraju P]

Yes. With this if condition it will trigger when due is in between -1d to next 7d.  

[Barış Özer]

Hi @Sreenivasaraju P 

Today, 1 day has passed for the ticket whose due date is August.

The date of August 18 due date says 1 day has passed.

I couldn't find where I am doing wrong in JQL.

[Hanan Golfeigen]

Hi Barış

I m working on same function JQL

could you please  publish the final JQL for all process ?

Thanks

HananG

[Barış Özer]

hi @Hanan Golfeigen 

below is my JQL function