Search for Portfolio Parent issues without any Child issues

[Robin Klein]

Hi!

I have some difficulty in creating a JQL (with Scriptrunner) that returns a list of Portfolio Parent Issues without any Portfolio Child issues. From Portfolio we have enabled two extra Parent levels in the issue type hierarchy. Below an overview where I just gave the two extra levels dummy names.

1. Portfolio Parent A
2. Portfolio Parent B
3. Epic
4. User Story

No I'm trying to create a JQL that returns a list of Portfolio Parent A issues that don't have a Portfolio Parent B child issue(s). I've used ScriptRunner functionality (PortfolioChildrenOf) to create some JQL's that didn't work.

Can you help me out? Thanks in advance!

Regards,
Robin

[Robin Klein · Accepted solution]

We found a solution already!

[Josh Steckler]

Hi Robin,

I've been watching this question, what solution did you find?

[Luk Lau]

Any solution? :)

[Terry Larrea]

Is there a jql solution? can your please provide the jql, thanks