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:
Can anyone support in resolving this issue?
Thanks !!
Community moderators have prevented the ability to post new answers.
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 ")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.