JQL query to return epics without story or task

[Dhanalakshmi s]

Can someone please do help on this issue.

[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:

1. Remove the label thisEpicHas0Children from all tickets that has this (reset)
2. Find all Epics in a project.

3. Use a "Related issues condition" to find all Epics with 0 children.

4. Add the label "thisEpicHas0Children" to those

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

[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. 

[Brandon Chin]

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. 

[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!

[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. 

[Dhanalakshmi s]

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.