Unable to get the Parent ticket status

[Ramu]

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

[Prosper Agwegiokhe]

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.

[Marc - Devoteam]

HI @Ramu 

What are you trying to achieve here?

You talk about Epic and child Epics

Epics have children, these are Stories, Tasks, etc...

Can you share screenshots of the hierarchy and what you exactly wang to query?

[Ramu]

Hi Marc ..

In my scenario, i have Parent EPICs and Child EPICs (no stories)

So, im trying to search all the open CHLD EPICs(in progress, Backlog) for which the PARENT EPICs were already closed ..

in the screen above, all my MAX (Parent EPICs) were closed ones ... so, i need to find all the Closed MAX(Parent EPICs) Epics where there are still OPEN(in progress, backlog) CHLD EPICs .. 

i can do this in Table Transformer in Confluence BUT, my need is that i need it in one JQL .. not sure if 'issuefunction ' or 'nested JQL' or any other function will help .. 

Hence, the ask .. Please help

[Marc - Devoteam]

HI @Ramu 

How is the link established, via issue links or parent field?

[Ramu]

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' ..

[Marc - Devoteam]

Hi @Ramu 

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

Apps:

1. JQL search extensions
2. JQL Tricks
3. Enhanced search for Jira