Hi,

 

How to write a query if I want to get the list of tickets which are changed from "Dev in progress" to "Dev complete" which crossed respective "due dates"?

Please help.

 

Regards,

Kalyan

3 answers

This widget could not be displayed.

Not sure what you mean by "crossed respective due dates" - can you explain or give an example.

 

 

This widget could not be displayed.

Hi Chris,

 

Thanks for the response, say for e.g there are 10 tickets in the project and

5 of them have due date of 21st but 2 of them were delivered on 22nd

3 of them have due date of 22nd and 1 of them delivered on 25th

2 of them have due date of 25th and both of them got delivered on 28th

 

I want to write a query on 29th to get the list of tickets where due date is crossed i.e I should get 2+1+2 tickets.

Regards,

Kalyan

This widget could not be displayed.

Another way of saying the same things is

resolution is empty and duedate < now()

This will give you all unresolved issues that are late.

Another option might be

status not in (Resolved, Closed) and duedate < now()

If you only want to show those issues that have transition from one status to another and are still open and have crossed their due dates you could used the changed operator.

status changed from "Dev in progress" to "Dev complete" and (resolution is empty and duedate < now())

Hope that helps.

Chris

 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

137 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you