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

[Sarah Burrell]

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 · Accepted solution]

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.  

[Sarah Burrell]

Thank you 

This works for 1 level 

Lets hope future Jira will enable parent or parent