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 ?
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
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:
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
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 ?
You can send a single email with the full list once a day - or every other day if you want.
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 John.
But I we do have rights to make such changes to JIRA.
Global admin has the rights.
Can somebody support me here ? Please
It looks like you're new here. Sign in or register to get started.
