dateCompare: Failed to get issues error while using ScriptRunner Enhanced Search

[Rajagopal Govindaraj]

I'm trying to filter the subtasks whose resolved date is greater than due date. I have created a custom field [status change] with datepicker and did an automation to store the custom field when the subtasks moved to done state.

Query used: project = Project1 AND type = Sub-task AND status = "Done" AND issueFunction in dateCompare(" ", "customfield_10061 > duedate ")

When I execute the query, i'm getting the below error:

dateCompare: Failed to get issues

 Can anyone support in resolving this issue?

Thanks !!

[Rajagopal Govindaraj]

Solution Found. subquery field in datecompare function should carry other filter details.

ex.,  issueFunction in dateCompare("project = Project1 AND type = Sub-task AND status = "Done" ", "customfield_10061 > duedate ")