Still nested query

[Sergii Shevchuk]

Hi team,

Please help )

I can't find or build the query that would list all issues that are related to all issues that are part of epic.

1. First part: list tickets in epic = `parent = "JIRA-1"`

assuming we have output: JIRA-2, JIRA-3, JIRA-4

2. Second part: list tickets related to current as = `issue in linkedIssues("JIRA-2", "relates to")`

I can't figure out how to combine two of them and output of first pass as the first argument to second....

Thanks in advance

[Bill Sheboy · Accepted solution]

Hi @Sergii Shevchuk 

You cannot do that in one JQL query with out-of-the-box features.

Some alternatives are:

• do the query in steps with multiple queries
  • for the epic, get the child list, and export their keys
  • for those keys, create a combined query with ORs the results together
• export the issues and perform the linkages/joins outside of Jira
• use a marketplace app to enhance JQL features
• create an automation for Jira rule to automate the multi-step query

Kind regards,
Bill

[Sergii Shevchuk]

Thank you

[Daniel Turczanski - JQL Search Extensions]

Hi @Sergii Shevchuk ,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in linkedIssuesOfQuery("parent=JIRA-1", "relates to")

Check out the documentation to see more examples.

I hope this helps!

Daniel