Find an Epic that contains children from other project

[Tal Harel]

im trying to find in JQL an Epic that one of his children are in the same project as Im woking on

For example:

Project = a.     
Epic = a1
    Story = a2
    Story = J5

I want to find the Epic that contains story from other specific project 

[Jack Nolddor _Sweet Bananas_]

Hi Tal_Harel,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search for Epics on 'PROJECTA' having at least one story on that project:

project = PROJECTA AND issue in epicsOf(' project = PROJECTA AND type = Story ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Kind Regards

[Daan Boesjes]

Hi Tal

Did you find the solution to your problem? 

I have more or less the same queston (im trying to find in JQL all Epics that one of his children are in the same project as Im woking on), breaking my head for quite some time now.

[Muhammad Ramzan(Atlassian Certified Master)]

You can achieve this by using a third party plugin like ScriptRunner or JQL Search extensions.

Here is example from  JQL Search Extensions for Jira & reports 

it will get all epics where stories belongs to project search.

issue in epicOf("type = story and project = SEARCH")

 :