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

[Karl Samson]

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

[John Funk]

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

[Karl Samson]

Hi John, yes we did thanks.

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

[Tim Perrault]

Hi @Karl Samson 

Unfortunately no. History searches aren't really supported by custom fields. There might be an app in the marketplace that could help, but not sure....

Thanks,

Tim

[Karl Samson]

Thanks for responding @Tim Perrault. We have actually resolved the issue and come up with a JQL Filter, usint ScriptRunner.

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

This does exactly what we wanted!

[Karl Samson]

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! :)