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

[Keith Adams]

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]

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

[Keith Adams]

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]

@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.