nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Jack Nolddor [Sweet Bananas]

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

All comments

Jack Nolddor [Sweet Bananas]

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server