Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,414,268
Community Members
 
Community Events
170
Community Groups

Search for EPICS with no stories

Can I write a JQL for getting all the EPICS in the project that do not have stories under them.

3 answers

3 votes

Not without an add-on. For example Scriptrunner provides the following option…

Issuetype = epic  and issuefunction not in haslinktype (“epic-story link”)

That doesn't work even with ScriptRunner. 

Jack Brickey Community Leader Dec 17, 2021

This doesn’t work?

issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link")
Like David Kollm likes this

It works today, I'm not sure what my issue was last week. 

Vanilla JQL doesn't support it. You can export your issues to spreadsheet and process the data there. Obviously it only works for one off jobs.

You can find such epics with our app JQL Search Extensions.

If you install it you'll be able to perform this search:

issuesInEpicCount = 0

 I hope this helps!

We have this addon, we've tried the search, and it returns a single epic.  However, we have several epics in our project that have no issues in them, that are not returned by this query.
From what I can see, the epic the query finds doesn't have any links to other epics, but the epics we have with no stories that the query does NOT find are linked to at least one other epic. 
So I'm guessing but not certain that maybe the addon is counting "links" as "issues in the epic" even though the links are to other epics that relate to ours or that share dependencies.

Hi @Kimberly Luttenbacher , please create a support request. It's the quickest way to get help with JQL Search Extensions. Thanks!

0 votes

Hi @TEMPVIMAE  -- Welcome to the Atlassian Community!

How often do you need to do this, and do you have funds to purchase marketplace addons?

  • When you need this once: consider exporting your issues to a spreadsheet and perform the comparison there
  • When you need this often and have funds for addons: consider marketplace addons like @Jack Brickey suggests
  • When you need this often and do not have funds: consider using a scheduled automation rule to either count the children and email you, or add the count to a custom field in the epic and then you can report on it later with JQL

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events