How to Iimit roadmap Initiatives and Themes to those that are parents of issues in another project?

[Deleted user]

I'm setting up an Advanced Roadmap. 

My company has a project that houses all the Themes and Initiatives for the company, and my project has all of my team's work. I want my plan to include the themes and initiatives from the company project so we can see how our work relates to them, but including them as a source pulls in ALL of the company Themes and Initiatives, of which there are a lot. I'd like to only include the Themes and Initiatives that have children in my project to reduce the clutter in my plan.

The Themes and Initiatives need to live at the company project level as they are often shared by many teams.

I thought to try and change the issue source for the company level issues. Instead of pulling them all in, I could create a filter - but I can't seem to figure out how to write a JQL statement that would select only issues where the Initiative has a child in my project, and where the Theme is the parent of one of the previous Initiatives. 

Is there a better way to do this or a JQL that will only grab the relevant Themes and Initiatives?

[Laurie Sciutti]

Hi @[deleted] and welcome!   If you use ScriptRunner, you can use the issueFunction in portfolioParentsOf(Subquery) function.  https://docs.adaptavist.com/sr4js/8.2.1/features/jql-functions/included-jql-functions/portfolio#portfolioParentsOf 

[Deleted user]

Thanks - any ideas of how this might work without a paid add-on? My org doesn't have it and I probably can't convince them to part with a chunk of money every year so I can have a cleaner roadmap for my project. 

I'll just use this moment to rail against how it seems like 90% of the time I get stuck the answer is "well, if you use ScriptRunner..." It just feels like there are too many basic things that JQL can't do out of the box and requires a paid addon.