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; } } }

JQL nested parent function

Christian Scharrer_rwbndg

I want to write a JQL query that delivers all tasks and their subtasks that are linked to an Epic. It is a team-managed project which brings some JQL restrictions.

the query

parent in (EPIC-1, ... , EPIC-N)

delivers all task or user stories.

I hoped that a nested query like

parent in (parent in (EPIC-1, ... , EPIC-N))

delivers all sub-tasks of the corresponding stories, but it doesn't work. Any ideas how I could solve this?

Accepted answers

Charlotte Santos -Appfire-

Hi @Christian Scharrer

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to display all stories and subtasks linked to an Epic:

issue in childrenOfIssuesInQueryRecursive(“issuekey in (EPIC-1, EPIC-2)”)

Please note that we have created a support ticket https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2/SEARCH-1121 in our portal, and we request you to sign in to the portal and let us know the username so that we can mark you as the reporter, and then you will be able to access the ticket.

Please find the below link to signup to the portal: https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2

Looking forward to hearing from you!

Thanks,
Charlotte

All comments

Markus Fredén

Hi @Christian Scharrer ,

You can make use of the JQL function "sssueFunction";

parent in (EPIC-1, ..., EPIC-N) OR issueFunction in linkedIssuesOf("parent in (EPIC-1, ..., EPIC-N)")

/Markus

Trudy P Claspill

@Christian Scharrer

There is not support for nesting filters like that in native JQL.

And note that "issueFunction in linkedIssuesOf" suggested by @Markus Fredén is not native Jira functionality.

That is available only if you have the appropriate third party app installed; i.e. Adaptavist Enhanced Search or Adaptavist ScriptRunner.

Charlotte Santos -Appfire-

Hi @Christian Scharrer

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to display all stories and subtasks linked to an Epic:

issue in childrenOfIssuesInQueryRecursive(“issuekey in (EPIC-1, EPIC-2)”)

Please find the below link to signup to the portal: https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2

Looking forward to hearing from you!

Thanks,
Charlotte

Dan Tombs

Hey @Charlotte Santos -Appfire-

Just want to bring this one back up. Can the extensions app go higher then epic in terms of the recursive JQL.

If we inputted the following JQL for hierarchy below would it return all results issues below:

issue in childrenOfIssuesInQueryRecursive(“issuekey in (COPS-1)”)

COPS-1 (project)
- COPS-2 (workstream)
  - COPS-5 (epic)
    - COPS-8 (story)
    - COPS-9 (story)
      - COPS-10 (sub-task)
  - COPS-6 (epic)
- COPS-3 (workstream)
  - COPS-7 (epic)
- COPS-4 (workstream)

Charlotte Santos -Appfire-

Hi @Dan Tombs

Yes, it can go higher than epics. You would get all of those results.

Give it a try, you have 30 days to test the app for free: JQL Search Extensions for Jira

And if you need any help with the queries you can open a ticket for us in our portal.

Regards,

Charlotte

Dan Tombs

@Charlotte Santos -Appfire-

Thanks for the note. I'll take a look and reach out to your support team if I have any questions.

Christian Scharrer_rwbndg

This doesn't work in Jira cloud. This was the answer (but the link doesn't work):

The "linkedIssuesOf" JQL function provided by "Adaptavist Scriptrunner" for Jira Server works differently in Jira Cloud. Run it directly in "Enhanced Search" instead. See the documentation for more details: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions

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