Query between JIRA Portfolio Advanced Roadmaps Project & JIRA Project

[Shankar Dharmaraj]

Hi all

I was in the training with Joanna Thurmann and i shared with her my issue

We have implemented Advanced Roadmaps (JIRA Portfolio) and standard JIRA. Our Initiatives, Sub-Initiatives, EPICs are in Portfolio & our JIRA (stories, sub-tasks) are in JIRA project. 

1. When we run a query with the EPIC, we get the EPIC link, key but when we extract to excel the EPIC link throws the key and not the name. We tried adding the EPIC summary but it comes out blank in the JQL and also in the extract

2. I cannot get the related Sub-Intiatives / Initiatives to this story how can i get them via a JQL query. 

Thanks 

[Joanna Thurmann]

Hi @Shankar Dharmaraj - here is a reply from our dev folks. 
1 . Those fields (Epic Name/ link) are platform things, unrelated to ARJ. The behaviour here seems to be intended. I don't know a way to get the name in an export.
2. Cloud doesn't have the JQL function to get the parents of an issue but Server/DC does have one (issuekey in parentIssuesOf("") )