search for reporter update over 5 days ago

[Joshua Lawrence]

I am looking to find a way to search for tickets that are still open where the requester's last update was over 5 days ago.  When I do "updated <= 5d" it will list if they or I updated less than 5 days ago, I want to list if their last update was within 5 days

[Jack Brickey · Accepted solution]

Hi @Joshua Lawrence , native JQL cannot get you there. You might consider an app addon or use a custom date field and automation to update the field each time the customer reporter comments/updates. Then you can use JQL to interrogate the date.

[Joshua Lawrence]

Thanks, I'll have to look into that

[Marc -Devoteam-]

Hi @Joshua Lawrence 

Use updated >= -5d

[Joshua Lawrence]

Thank you but I am looking for a result when the reporter's last update is over 5 days old.  if I use "updated<=5d" returns if the user or I updated it.  I am looking for something like "reporter_last_update > 5d" and that will return a ticket if the user hasn't updated within the past  5 days, so I can find old/dead tickets