JQL for Compliance Date mismatch between stories and sub-tasks

[Darren Burt]

I am looking for assistance in the titled query where we would have a Compliance date in the main story but this does not match with the Compliance date in the sub task.

We do not have access to Scriptrunners or automation at this point.

Project = xxxx and type = story and status not in (AAA, BBB, CCC) and 'Compliance Date' is not empty and issufunction in parentsof("project = XXXX and status not in (AAA, BBB, CCC) ...........

And that is where I am stuck.

Any help, greatly appreciated

[Aswin Raj D]

Hi Darren,
Unfortunately, JQL on its own doesn't allow direct comparison of fields between parent and sub-tasks, such as checking if a sub-task's Compliance Date is different from the parent Story's Compliance Date. This kind of cross-issue field comparison isn't natively supported. If your team can temporarily label or flag sub-tasks that have non-matching dates, you could filter like:
project = XXXX AND issuetype = Story AND issueFunction in parentsOf("labels = compliance-date-mismatch")

[Aron Gombas _Midori_]

You can't do this out of the box.

If you introduced a new boolean custom field "Compliate date match" and maintain its true/false value automatically, then it would work very nicely. But the maintenance logic would require ScriptRunner or automation rules or some other mechanism, as you noted.

[Darren Burt]

Thank you. I appreciate the response