Hi, i need a query to show the tickets created greater than 4 hours
Thanks
The advanced query below should tell you the basics:
created < -4h
The "created" field is the date/time the issue was created, and the -4h is worked out as " now, minus 4 hours". If you're going to work with relative times more, be aware of that calculation, as it is purely relative to "now", it does not take account of working hours.
You probably want to combine that with things like "ignore closed issues", so maybe "created < -4h and resolution is empty"
thanks a lot
And if I wanted to use minutes it would be : created < -105m (for 1h45m) ?
Yep, should be.
It looks like you're new here. Sign in or register to get started.