JQL to show all epics, stories and subtasks underneath a portfolio epic

[James Evans]

Greetings all,

I’ve been tasked with the following;

”Can you make me a jql export that shows all of the (1) epics, (2) stories and (3) associated subtasks for the entries underneath my portfolio epic? I need to check the overall percent complete”

I know just enough JQL to be dangerous but, not enough to be productive :) Any help would be appreciated. Thanks in advance....

[Mohamed Riza]

Hi @James Evans,

You should be able to achieve this if you have Scriptrunner installed, which has the 

portfolioChildrenOf

function. You may review: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_portfoliochildrenof