Initiatives and parent links - can anyone provide JQL for grand parent

Sarah Burrell_t8xjyx

hello

We are using advanced roadmaps and have a multi tiered approach

example  WorkStream > Initiatives > Epics

I wish to run some sql for epics where workstream = 'xxxxxx'

ie to show the grandparent

 

I may also wish to then select a value on the workstream

 

anyone know if you can run some sort of parent of (parent) or of any apps ?

 

thanks 

Mark Segall

Hi @Sarah Burrell - Unfortunately, JQL capability at this time for issue hierarchies is very limited.  You can use:

issue in portfolioChildOf("YOURISSUEKEY")

This will get child detail against a specific issue type in the hierarchy and you can marry that up with specific JQL for the children it returns.  For example, if I wanted to get just the epics for two specific workstreams where child status = In Progress, I'd do this:

(issue in portfolioChildOf("WS-123") OR issue in portfolioChildOf("WS-456")) AND issueType = Epic AND status = "In Progress"

However, you cannot perform a query where you want to say, dynamically return all children of all workstreams where status = "In Progress" because portfolioChildOf("") requires an explicit issue key. 

Lastly, there is no inverse of the child lookup like portfolioParentOf(""), so being able to search against parents is not possible.