Unable to get the Parent ticket status

Question

Dear All ..

i have a scenario where i need to do a JQL of finding OPEN child issues(Epics) but Closed/Done Parent Tickets(Epics/issues) ..

in other words, find all the Closed Parent Epics where their child EPIC s are still open

with my tryout using 'Parent Link' is EMPTY is the only option i see which is not relevant to my ask ..

Please help

Marc -Devoteam- · Answer

Hi @Ramu

This can be done with the ootb JQL options. You will need an app from the marketplace.

Apps:

* JQL search extensions
* JQL Tricks
* Enhanced search for Jira

Prosper Agwegiokhe · Answer

Hi @Ramu ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.

The app I work for, JQL Search Extensions for Jira, you can use the query below to get the results for your use case:

issue in linkedIssuesOfQuery("type=Epic AND status='Done'", "is blocked by") and type = Epic and status = "To Do"

However, depending on how your epics are linked to each other, you might need to modify the "is blocked by".

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

Ramu_kd54ib · Answer

Hey ..

In the CHLD EPIC, the MAX EPIC appears as 'Parent Link'

in other words,

in the MAX EPICS, the CHLD EPICs appears under 'Child Issues' ..