How to filter all tickets, regardless of project, that has a parent in a specific project

[jorge_negrete]

Hi All!

I'm trying to create a plan that includes Epics in a specific project (E.g. Project 'ABC'), which may have tasks/stories that belong to other projects without having to set up a filter that relies on adding a label to each ticket that sits outside the project where the Epic is from. 

Is there a way to create a filter that automatically filters in ALL tickets with a "Parent" that sits in Project 'ABC'?

Thanks!

Jorge

[Christos Markoulatos]

Hey @jorge_negrete 👋 welcome to the community!

Native JQL can’t do this automatically. You can only query one parent at a time like:

parent = ABC-123

To pull all children of Epics in Space ABC, here are your options as far as I know:

Plans – works even if issues aren’t in a plan

issue in portfolioChildIssuesOf("project = ABC")

ScriptRunner

issueFunction in childrenOfIssuesInQueryRecursive("project = ABC")

3rd-party apps

• Advanced JQL Functions (Cloud)
• Enhanced Search (Adaptavist) (Cloud)
• More Extension for JQL (Cloud & DC)
• JQL Booster Pack (DC only)
• Links Hierarchy (Cloud & DC)

Hope this helps!

[jorge_negrete]

Hi Christos, 

Thanks for your reply! I'll play around with the options above. Just for clarity, my understanding is that "Advanced Roadmaps" and "Plans" are the same thing aren't they? "Plans" is just the new name for them... just like "Projects" will soon be renamed "Spaces"? Did you mean to say "Project" in the first option you mentioned instead of "Plan"?

[Christos Markoulatos]

Hi @jorge_negrete 

You’re absolutely right. Plans is the current name for what used to be Advanced Roadmaps, so they’re the same feature, its hard to keep up with all the changes. And yes, Projects are being renamed to Spaces across Jira Cloud, . As for your last question, I really did mean Plan because the JQL function uses the hierarchy defined in Plans, not whether the issues belong to a specific Space.