JQL for a list of stories from Epics that have a specific Parent Link

[Gowri Kumar]

Hi All,

I am trying out JIRA Portfolio and have the following hierarchy:

Initiative -> Epic -> Story -> Sub-Task

I want to write a JQL query where I can get the stories from Epics that have a specific Parent Link. It seemed easy enough to write it using Script Runnuer IssueFunction, but the query seems to written epics from other Initiatives as well.

I am not sure what's wrong, but could this be because the Epics were previously stories and were converted to Epics.

Can someone please help me wiht this? Do let me know if anymore details are needed.

[Thomas · Accepted solution]

Hi @Gowri Kumar,

Portfolio 2.4.0 introduced some changes to the Parent Link field so to get you the best answer I'd like to confirm the version you are using (Or if you are on a Cloud offering).

Then I'd be interested in the result of the following JQL Query:

"Parent Link" IN (TRAN-5) AND Key IN (GSD-370, GSD-4838, GSD-4702)

That might help figure out if the problem happens due to Portfolio JQL functions or Scriptrunner JQL functions!

Cheers,

Thomas

[Gowri Kumar]

Thanks for your help. I just managed to figure out the problem.

The 'Move' of these issues were done via System Import rather than UI. So the 'Epic Link' was still in place (even though you can't retrieve it via UI.

The solution was to move the issue back to story and then again to Epic via the UI.

[Thomas]

While Portfolio will ignore links that do not make sense (Initiative with Epic Link for example) it's true that the epic link would still be there on a JIRA point of view and be returned as part functions like issuesInEpics.

Glad you figured out the problem!

Cheers,

Thomas