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 query to return epics without story or task

Dhanalakshmi s_l01e0l

Can someone please do help on this issue.

Accepted answers

All comments

John Funk

Hi @Dhanalakshmi s - Welcome to the Atlassian Community!

You will not be able to do this without an add-on app like ScriptRunner.

Sudarsana G

issuetype = Epic AND issueFunction not in hasLinks("is epic of") AND issueFunction not in linkedIssuesOf("issuetype = Story OR issuetype = Task")

issuetype = Epic: Filters issues to only include epics.
issueFunction not in hasLinks("is epic of"): Excludes epics that are linked to other epics (since an epic cannot be a child of another epic).
issueFunction not in linkedIssuesOf("issuetype = Story OR issuetype = Task"): Excludes epics that are linked to stories or tasks.

This query will return epics that do not have any linked stories or tasks.

John Funk

This will need the ScriptRunner add-on.

Olliver Ordell

Hi @Dhanalakshmi s

I got the same request from a colleague and solved it without add-ons. It can be done with an automation that adds a specific label to Epics with no children.

The trigger can we scheduled to run once a day, or just when someone creates an issue.

The automation does the following:

Remove the label thisEpicHas0Children from all tickets that has this (reset)
Find all Epics in a project.
Use a "Related issues condition" to find all Epics with 0 children.
Add the label "thisEpicHas0Children" to those

You can now make a JQL query that searches for all tickets with this label.

Charlotte Santos -Appfire-

Hi @Dhanalakshmi s

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

Unfortunately, natively, 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 get all epics with 0 children:

issuesInEpicCount = 0

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Brandon Chin_byyntw

Hi @Dhanalakshmi s

I am part of the Customer Success Team for ScriptRunner. This can be accomplished with ScriptRunner add on. You can start a trial to try it for yourself and use the suggestion by @Sudarsana G. I am happy to go through the features with you if you are interested.

Dhanalakshmi s_l01e0l

Hi Sudarsana G

issuetype = Epic AND issueFunction not in hasLinks("is epic of") AND issueFunction not in linkedIssuesOf("issuetype = Story OR issuetype = Task") it's working fine when we disable the hasLinks() in Powerscript for Jira plugin and JQL Tricky plugin also we have disable it so can you please help me out with some other alternative ways.

Thank you in advance.

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-server