How write a JQL to find all child issues for which Start Date <= parent issue Due date?

[Anna Khitsan]

How write a JQL to find all child issues for which Start Date <= parent issue Due date?

[Shiva Kumar Hiremath]

Hello @Anna Khitsan ,

If you are using scriptrunner you can use the JQL

issueFunction in issueFieldMatch("parent", "dueDate", "<= startDate")

[Mariana Silveira Sales]

Hi @Anna Khitsan 

There is no native JQL functionality that allows for direct comparisons between fields of parent and child issues. However, you can achieve this natively by implementing a workaround that leverages custom fields and automation.

Create a Custom Field (e.g., Parent Due Date) to store the parent's Due Date in child issues.

Use Automation to Copy Parent's Due Date:Set up an automation rule to copy the parent's Due Date to the child issues whenever the parent issue is updated.

Trigger: Field value change (trigger when Due Date is updated in parent issue).
Condition: Issue type is the parent issue type (e.g., Epic, Task).
Action: Branch the rule for child issues (e.g., "For subtasks" or "For issues in Epic").
Action in Branch: Copy the parent's Due Date to the custom field in the child issues.
Query Using JQL: Once the parent's Due Date is copied into child issues, you can use native JQL like this:

"Start Date" <= "Parent Due Date"

[Anna Khitsan]

Hi Mariana,

Thank you for answer! 

But I think Automation is currently available just in Jira Cloud, and my Jira hosted in my organization's Data Center.