Need to understand how to control the values of updated in a JQL query

Question

I have a project where I've been asked to add a "we're working on this" comment to any ticket opened by a customer which hasn't been updated in the last hour. Does anybody know how I do this with the "updated" component of JQL? Thanks, Keith

P.s. I've been using updated>-1 hour but that just shows me the tickets that HAVE been updated in the last hour.

Michael Andolfatto · Answer

@Keith Adams  could you double check the JQL? You originally said updated > -1h, I'm saying the reverse, updated < -1h

From Atlassian's own documentation you can see this in action

* Find issues that were last updated more than two weeks ago:
updated < "-2w"

I've also tested it and it has worked for my issues.

Keith Adams_x6q70k · Answer

Thanks Michael, that's actually what I was using originally, but it's not working. Instead it's returning ONLY the tickets which were updated within the past hour.

Keith

Michael Andolfatto · Answer

updated < -1h will return issues where the updated date is more than one hour

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-UpdatedUpdatedDateupdatedDateUpdated