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,298,259
Community Members
 
Community Events
165
Community Groups

JQL query for epics in progress and stories status equal to done.

Edited

Hie team,

 

We have a agile project running.And we need such a query that displays all the epics whose stories are resolved but the epic is not equal to done but in progress or in specification ? 

2 answers

Unfortunately it's not possible in basic JQL.

You can either try this plugin https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?tab=overview&hosting=cloud which enhances the JQL or you can try to export issues to Excel, and create a basic pivot table based on "Epic link" field to group stories with epics, filter epics' statuses to "In progress" and manually find which one has any open stories inside

Thanks for the reply Marcin.

But bacially even after exporting it will take all the epics in account. 

 

If I understand U wrong could You please ellaborate.

 

Or is it possible to display all the strories in done state and display the epic link as well in jql query ?

Yes basicaly i followed what u said-

 

1) I created a JQL query for all epics that are in not equal to done.

2) Then all epics were displayed as jql.

3) How I did export this to excel.

So to check the stories in this epics do u mean to check them manually by clicking each epic link ? or U mean something else ? 

 

Thanks 

0 votes
John M Funk Community Leader Jun 20, 2022

Hi @vinayak biradar  - Welcome to the Atlassian Community!

You should be able to create an automation rule that is run on a scheduled trigger to send once a day and sends an email with the list of open Epics. Here is an example:

screenshot.png

Hei John

 

Thanks. But in our project the epics are assigned to one single user the project manager.

So he will receive all the emails which we dont want.

 

We want JQL to display all epics in progress state and all stories are done.

 

Thanks

Like John M Funk likes this
John M Funk Community Leader Jun 20, 2022

You can send a single email with the full list once a day - or every other day if you want. 

Thanks John.

But I we do have rights to make such changes to JIRA.

Global admin has the rights. 

Like John M Funk likes this
John M Funk Community Leader Jun 21, 2022

Well, I would have your admin add it.  ;-)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,836 views 37 48
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you