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 to show all issues AND subtasks in the Epic

Shawn Wallack_yw7lis

I use JQL Tricks to return all issues that have a certain link type. That query is:

issue in parent("issue in linkedAllIssues(CH-58,\"contains the scope\")") OR issue in linkedAllIssues(CH-58, "contains the scope") OR issuekey = CH-58

This returns the issues that have a link type "contains the scope" with CH-58 (CH stands for "charter" by the way).

Unfortunately, it does not get deeper than the epic. So, for example, if it returns epic SF-99, SF-100, and SF-101, it does not return the issues and subtasks belonging to those epics.

Basically, in addition to what is already being returned by the JQL above, I need the JQL to also return any issue and subtasks whose epic link “is scope within” the selected charter.

Accepted answers

All comments

Mikael Sandberg

You need something like ScriptRunner or JQL Tricks to do nested JQL queries. I have not used ScriptRunner's JQL function for it (we have both plugins), but we are using JQL Tricks to search for all issues and sub tasks that are linked to specific epics.

Shawn Wallack_yw7lis

Thanks. But... can you share the JQL?

Mikael Sandberg

Here is a query we use to get all issues linked to a specific epic:

project = X AND issue in issuesWhereEpicIn("project = X AND issuekey = X-XXX")

In your case your query should look something like this (I have not tested it so you may have to tweak it a bit):

issuesWhereEpicIn ("issue in parent("issue in linkedAllIssues(CH-58,\"contains the scope\")") OR issue in linkedAllIssues(CH-58, "contains the scope") OR issuekey = CH-58")

Shawn Wallack_yw7lis

Thank you. I sincerely appreciate the help. When I enter that query into the search box, however, I get an error:

Error in the JQL Query: Expecting operator but got '('. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 19)

Junio Fernandes

In my case I use AM Utils (free add-on) to search all issues and subtasks on it:

A simple example:

issuekey in (issuesSubtasks("'Epic Link' = XXX-99")) ORDER BY Rank ASC

With this I can make boards that swinlanes with stories or projects besides the Epic Link.

Anna Kubaty

I use:

parentEpic = AB-12345

or:

parentEpic in (AB-12345, AB-67890)

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software

script

jql-tricks