JQL find subtask of child issues

[PEGE]

Is is posible to combine te JQL issue function issueFunction in portfolioChildrenOf and issueFunction issueFunction in subtasksOf?

Explanation:

We have an issuetype initiative and we have an issuetype business epic. Business epics are child issues of the initiatives. We've created sub-tasks which are linked to the business-epics.

What I'm trying to achieve is to make a list of sub-tasks when the key of the initiative is the I only information I have.

It has to be a JQL solution (not scriptrunner) because I need to use te query in a Jira dashboard.

I've tried diffrent ways nesting the JQL's (for one example see below) but that didn't work.

issueFunction in subtasksOf("issueFunction in portfolioChildrenOf("key=Initiative-1")")

Is this even posible and has anyone an idea how to achieve this?

[Florian Bonniec · Accepted solution]

Hi @PEGE 

Yes you can use any JQL as a sub-query including issueFunction.

If you are looking to have all subtask under a Business Epic that is linked to Initative-1 you can use:

issueFunction in subtasksOf("issueFunction in portfolioChildrenOf('key=Initiative-1')")

Make sure to use ' and not " in the sub query or you will have to escape them using \"

Reagdrs

[PEGE]

Hi @Florian Bonniec ,

Thanks a lot!! It worked! 

Spend so much time on this but couldn't get is to work because of that ".