JQL to find subtasks updated more recently than parents

Question

I have a requirement to create a filter that will return subtasks that have been updated more recently than their parent. I'm pretty sure I can do this via Scriptrunners issue functions but I seem to be having a bit of a mental block on how to go about it. Can anyone help?

Graham Horsman · Answer

Thanks Jamie.

JamieA · Answer

I cannot think if an easy way to do it with Script Runner JQL functions. I want to be able to do:

issueFunction in expression("issuetype in subTaskIssueTypes()", "updated > parentObject.updated")

but that doesn't work. I created an issue because this has come up before: https://jamieechlin.atlassian.net/browse/GRV-587

You could do it with a groovy script or db query or write your own function, but none of them satisfactory. Maybe one of the other plugins that does JQL functions has this.