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 · Accepted solution]

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

[kenneth.gomes]

Thank you Kate, that solution works :)

Kenneth

[Kalyan Sattaluri]

Hello @kenneth.gomes 

In our firm, becuase of how our Portfolio Epics vs Normal Epics are set up in Jira, below query gives us the data:

issueFunction in portfolioChildrenOf("Project = UIP and status = Funnel")

AND status = "Inprogress"

And issuetype not in (Story, Task, Sub-task, Bug)

Please let me know if its the same for you as well.

[kenneth.gomes]

Hi Kalyan,

Thank you for your suggestion but when I tried using your query with ScriptRunner Enhanced Search and I keep running into the error "Function 'portfolioChildrenOf' does not exist"

I might have to find an alternative to the above function

Kenneth

[Kalyan Sattaluri]

Hello @kenneth.gomes 

Sorry about that, I think there is a difference between data center and cloud when it comes to script runner functions for portfolio epics. Hopefully others who are familiar can share more details.

[kenneth.gomes]

Hi Kalyan,

I am thankful that you tried to help :)

Kenneth