Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to find epic without stories ?

Kagithala Babu Anvesh October 21, 2019

We have a requirement , that have to show the epics which don't have stories in it.

2 answers

2 accepted

4 votes
Answer accepted
Jack Nolddor _Sweet Bananas_
Atlassian Partner
October 21, 2019

Hello all,

What about to use JQL Booster Pack (FREE) and type the following?

 

type = Epic and issue not in epicsOf('"Epic Link" IS NOT EMPTY')


Regards

Kagithala Babu Anvesh October 21, 2019

Hi , will check and update to you

Kagithala Babu Anvesh October 21, 2019

Thank you @Jack Nolddor _Sweet Bananas_  . it's working fine. Thank you So much

1 vote
Answer accepted
Mohamed Benziane
Community Champion
October 21, 2019

Hello,

It seems that it's not possible without a paid plugin like scriptrunner.

If you have this plugin you can use this :

issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link")

 

Hope this helps 

Kagithala Babu Anvesh October 21, 2019

hi  thanks for the reply.

any other option without going for a plugin 

Deleted user October 21, 2019

I don't find anything, what is the problem here?

error epic-story link.PNG

Kagithala Babu Anvesh October 21, 2019

Do you have script runner add-on in jira

Like Mohamed Benziane likes this
Mohamed Benziane
Community Champion
October 21, 2019

You need the scriptrunner plugin to use this jql syntax

Deleted user October 21, 2019

Yes, I have the scriptrunner plugin installed.

Mohamed Benziane
Community Champion
October 21, 2019

Hello Ulrika,

You're looking for epic without stories ? If so please try this :

issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link")
Deleted user October 21, 2019

No difference, same result. Could not find linktype.

Mohamed Benziane
Community Champion
October 21, 2019

Ok i think i found the issue. you have a duplicate issuetype name.

You have Epic-Story Link in double. You can check in this page 

JIRA-URL/secure/admin/ViewLinkTypes!default.jspa

You need to change the name of one of them

 

Hope this helps

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, out of office, loom, confluence, async collaboration, meeting recaps, remote teamwork, team alignment, knowledge sharing, AI-powered notes, productivity tools, workforce continuity, teamwork collection

Put your meeting notes on autopilot with Loom + Confluence

AI-powered meeting notes keep work moving even if you’re out of the office. Enjoy your well-deserved time off and return refreshed, confident you’ll catch up in no time.

Learn more
AUG Leaders

Atlassian Community Events