Ticket Over due

Hello,

We would like to Query the tickets which are Over due and the tickets which are about to due in 3 days.

Can anyone please help with the Queries.

Thanks in Advance.

Madhu

2 answers

2 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

Hi @Madhu Reddy

due < now() and resolution is EMPTY
due > now() and due < 3d and resolution is EMPTY

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

Answer accepted

Hi @Madhu Reddy

Overdue tickets

due <= now()

due >= "0"

About to be due in 3 days.

due <= startOfDay("+3d")

Thanks

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

Comment

Was this helpful?

Thanks!

Jira

Community showcase

Understanding Issue Types in Jira
What are Issues in Jira
What’s the difference between a kanban board and a Scrum board?
New Portfolio Cloud Experience Beta
Announcement: Project Level Email Notifications for next-gen projects on JSW/JSD

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Ticket Over due

2 answers

2 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events