Trying to find all parents (portfolio epics) for children (epics)

kenneth.gomes

I am trying to write a query to find all children epics for a given portfolio epic.

Criteria;

Parent

• Project = UIP
• Status = Funnel

Children

• project = any
• Status = Inprogress 

I am stuck at this query as my results keep giving me 0 results even though the inner query works as intended.

I started with finding all the children where the project = UIP and the child status is in Inprogress and the issue type is not in Story, Task, Sub-task, Bug. From there I tried to highlight all the parents so I can start narrowing down my results.

issueFunction in parentsOf("issueFunction in childrenOf('project = UIP and status = Inprogress' and issueType not in (Story, Task, Sub-task, Bug))")

Any direction will be helpful

 

Kate Kabir

Hi @kenneth.gomes 

I hope you are doing great.

You cannot have an IssueFunction nested into another issueFunction,  then you will need  to save the sub-filter with this query and then refer it in the main issueFunction.

Create the JQL search used by your board filter or quick filter and reference the saved filter using the syntax shown below which will return the results of your filter using the JQL functions provided by ScriptRunner.

filter = "<NameOfFilterhere>"

I have a parentOf JQL query and call another childrenOf saved filter.

Potentially, you can use the below JQL query as an example/guide:

issueFunction in parentsOf(Project = STRAW AND issueType = Epic) AND Status = Done AND filter = "childrenOf"

I have another saved filter for the childrenOf JQL query name "childrenOf".

I hope this helps.

Kind Regards

Kate