JQL query

[annie annie]

Hi, i need a query to show the tickets created greater than 4 hours

Thanks

[Nic Brough -Adaptavist- · Accepted solution]

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"

[annie annie]

thanks a lot

[annie annie]

And if I wanted to use minutes it would be : created < -105m (for 1h45m) ?

[Nic Brough -Adaptavist-]

Yep, should be.