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 ?
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
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 ?
👋 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...
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