Community
Products
Jira
Questions
I want the JQL which refers to the Tickets which are having the due date is today

I want the JQL which refers to the Tickets which are having the due date is today

Hello dear Community,

I want the JQL which refers to the Tickets which are having the due date is today, Every day I want to run this jql , with the Event Scheduler automation rule to check, if any Due date is today any tickets are there, and I want to notify the support team to alert them to do something on the tickets

the Event Scheduler automation ruler has been set up for the UTC 9:00 am Time Zone

Pls guide me.
Thanks in advance.

Regards,
Suneel

2 answers

1 accepted

1 vote

Answer accepted

Hi @suneel babu

Use the JQL clause:

DueDate >= startOfDay() and DueDate <= endOfDay()

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Hi @suneel babu!

You should be able to accomplish this by adding duedate = startofDay() to the query of your choice. But it might be good to limit it to the project(s) you want it to trigger from.

Best, Tobias

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

I want the JQL which refers to the Tickets which are having the due date is today

2 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events