JQL filter for issues that have had a certain custom field updated in the last 7 days

Question

Hi all, I've been asked if it is possible to write a JQL filter to list all issues that have had a certain custom field updated to a certain value in the last 7 days?

Eg. Project = "F35 Change" AND issueFunction in lastUpdated('-7d') AND "Stakeholder" = '430 Operations' AND Status not in ("CI - Complete","CI - Complete 1","CI - DONE") ORDER BY Updated DESC.

I know this isn't correct, but hopefully it explains what I'm trying to achieve?

We are using ScriptRunner v6.39.0

Karl Samson_71fk2j · Answer

Hi John, yes we did thanks.

"project = "F35 Change" AND issueFunction in issueFieldMatch("updated > '-7d'",Stakeholder, "430 Operations.*")"

John Funk · Answer

Hey @Karl Samson  - Did you ever get this solved?

Karl Samson_71fk2j · Answer

Correction, hold that thought! Having scrutinised it further, it actually brings back ALL updates, not just issues with the field updated in the last 7 days! But watch this space, as I still think it can be done! :)