Seeking JQL to search issues by a specific field which has not been updated within a date range

[James Morris]

Seeking JQL to search issues by a specific custom field which has not been updated within a specific date range

[Trudy Claspill]

Hello @James Morris 

When you say you want to find issues that haven't been updated do you mean the issue overall hasn't been update or that the field specified in your JQL hasn't been updated?

@Mikael Sandberg 's response is relevant to looking at the overall Last Updated date for the issue, not for looking at the Last Updated date for the Custom Field.

Jira does not natively support functionality to query for issue based on the Last Updated date of a custom field. They do support that type of query for a small set of System Fields with the CHANGED operator.

You could use an Automation Rule and a another custom field to keep track of when your targeted custom field was last changed, and then search on that Custom Field Last Changed field.

There are also third party apps that extend JQL functionality to enable you to search on the Last Updated date for custom fields.

[James Morris]

Many thanks for the response.

The 2nd part of the reply is what I am interested in solving for so your reply was very helpful- thanks. 

[Trudy Claspill]

Glad to help.

If your question has been adequately answered, please consider marking the Answer as Accepted to help other users find posts with validated solutions.

[Mikael Sandberg]

Something like this would do it:

MyCustomField = Something AND updated < -5d

This one would get all issues were the custom field is set to Something and hasn't been updated in the past 5 days.

[Mikael Sandberg]

If you want to see within a specific range then something like this would do it:

MyCustomField = Something AND updated < -5d AND updated > -30d

You could replace the -5d with a date like "2022/12/31"