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

James Evans_8efpxl

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_s7j38y

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