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.
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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...
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!
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