Find issues that were created after a custom date field on parent

[Steve Beauchamp]

Hello.

In my Jira project, we use the following issue hierarchy:

Initiative
    Epic
        Task

I am looking for a way to search for Tasks that were created after a date specified in a custom date field on the Initiative.  

For example, I am trying to capture issues that match this scenario:

I create a Task on 6/4/2025 and link it to a Epic, which is linked to a parent Initiative with a "Custom Date" of 6/1/2025. 

To reduce complexity to start, I tried to go to just the Epic level -- i.e. find Tasks that are linked to an Epic with a "Custom Date" that is before the createdDate of the task. 

I tried the following query, which does not work:

type = task and issueFunction in issueFieldMatch("parent", "customfield_47018", "< createdDate")



Result: I get the following error

Error in the JQL Query: Expecting operator before the end of the query. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'.


Does anyone have a suggestion of how I can do this? 

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Steve Beauchamp

I suggest trying ScriptRunner's SideKick's AI and requesting it create a Jira Expression for your requirement to see if it can assist you.

Let me know how it goes.

Thank you and Kind regards,
Ram

[Gor Greyan]

Hi @Steve Beauchamp ,

Jira's native JQL can't compare fields against each other.

For your case, you can try to reach it via automation.

1. Trigger- Issue Created
2. Condition for the issue type: Issuetype = Task
3. Branch Rule: Parent(Epic)
4. Compare parent's customfield to {{issue.created}}
5. Action: Set customfield value true or set label

Then use the following JQL.

Project = "YouProject" and customfield_12345 = true/labels = true

Will be happy to hear that it worked.