Query for presenting Epics which have a parent Capability with a certain status

[Noam Guttman]

Hi all,

I'm trying to flush out all of the Epics in my project (called Farsight) which don't have an allocated fix version, and that their parent Capability's status isn't Open, Design, etc.

My current JQL is:

project = FARSIGHT AND type = Epic AND fixVersion is EMPTY AND resolution = Unresolved and component not in (admin)

Thanks,

 -Noam

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Noan,

Do you mind to further explain us what means "their parent Capability's status isn't Open, Design, etc."

What kind of relationship there is between epics and Capabilities? An image would help for sure!

Regards

[Noam Guttman]

Hey Jack,
I would like to see the Epics which have a parent link to a Capability, and that this Capability's status is not "Open" or "Design" but rather "Implementation" or "Activation".

Basically the Epic and Capability have a parent-child relationship.

[Jack Nolddor _Sweet Bananas_]

Ahá! I got it!

Do you use portfolio for jira, don't you? If so, I believe you must go for a third-party app to create such a complex query. Using i.e. JQL Booster Pack you can type the following:

project = FARSIGHT AND type = Epic AND issue IN portfolioChildOf("type = Capability AND status NOT IN (Open, Design)")

References:

• portfolioChildOf()

Hope this helps,
Regards

[Noam Guttman]

Thanks a lot!
I will see if I can add the 3rd party app.

Best,

 -Noam