EPICS without issues

[Enmanuelor Ortiz Lopez]

Any suggestion to show only Epics with no issues or tasks in a Dashboard, Report or Screen?

I tried with JQL but results that I don’t have the ScriptRunner add on to run it, So I’m looking for alternatives to show that information

[mauricio.groth · Accepted solution]

Hi @Enmanuelor Ortiz Lopez 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all epics with no issues or tasks in a Dashboard, Report or Screen.

issue not in epicsOfChildrenInQuery("") and type = epic

Check out the documentation for more examples. 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Trudy Claspill · Accepted solution]

Hello @Enmanuelor Ortiz Lopez 

Welcome to the community.

Are you open to use of a third party app, like ScriptRunner, or do you have any other apps that extend Jira search capabilities?

If you are not, an alternative is to use a custom field in the Epic issue type to keep track of whether or not child issue have been added to it. You would update that field using an Automation Rule when issues had the field containing their Parent Epic information were changed. And then you could create a filter based on that custom field to find the Epics where the field value indicated the Epic had no children.

The rule might have to be a bit complex as you would have to look at the change log for the child issue to see if the parent Epic info was changed and get the original and new values. Then you would have to look up each of those Epics, and then for each Epic look up if it had any child issues. Then you would set the custom field in the Epic based on whether or not the Epic had child issues. 

[Enmanuelor Ortiz Lopez]

Good anwsers Guys... Thanks a lot!