nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Bill Sheboy

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

All comments

Bill Sheboy

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud