Nested filter in childIssuesOf("")

[Arturs Kalnins]

I'm trying to scale our advanced roadmaps filter. 

We have multiple advanced filters projects with specific Epics

This is the current JQL i'm using:

project = SER and key in ("SER-1142", SER-1143, SER-1144) and (Status not in (Done, Resolved, Canceled) and "Epic Status" != Done) or (issuekey in childIssuesOf(SER-1142) OR issuekey in childIssuesOf(SER-1142)) or (issuekey in childIssuesOf(SER-1143) OR issuekey in childIssuesOf(SER-1143)) or (issuekey in childIssuesOf(SER-1144) OR issuekey in childIssuesOf(SER-1144))

The problem is, it is ABSOLUTELY not scaleable. What i'm trying to achieve is: 
By adding a label to a specific epic, it (and all childissues of the epic) would be added to roadmap 

I have created a filter "label = roadmap_q4_2024") and it would be a lot easier to just call out said filter within a new jql (such as childissues of("filter = Roadmap_Filter")) but it does not work. 


Any advice how to tackle this problem? 

thank you! 

[Sudarsana G · Accepted solution]

you're trying to create a JQL query that dynamically includes issues based on whether they belong to epics labeled with "roadmap_q4_2024". However, JQL does not support directly querying child issues of a filter.

One approach to achieve your goal is to use JQL functions provided by apps like ScriptRunner for Jira or Jira Misc Workflow Extensions (JMWE). These apps offer additional JQL functions that extend the capabilities of Jira's native JQL.

[Arturs Kalnins]

i'm in no position to add any applications to our JIRA instance as it is a big corporation. Is it possible to rewrite it to be a bit more dynamic?

[Arturs Kalnins]

@Sudarsana G How would one do this is scriptrunner? What function can I use for it being a dynamic?

[Sudarsana G]

May be like this issue in linkedIssuesOf("labels = roadmap_q4_2024")