Can ScriptRunner tell me the status of an epic link of a given issue (bug, story)?

[Randy O_Neal]

I'm fairly new to ScriptRunner... and I think I'm asking about something that can be accomplished.  I'm trying to us JQL to look at all issues for a particular project to find issues with an epic link ("Epic Link" != Empty) which points to an epic which does not have a status of Done.

What I'm ultimately trying to identify is any residual stories or bugs which are yet to be completed on a per epic basis so that I can chart them in a pie chart or bar graph (whichever fits best).  But I don't want to show completed epics; only active ones.

Can this be accomplished via ScriptRunner?

[Walter Buggenhout]

Hi @Randy O_Neal,

The below query in Scriptrunner enhanced search would return all issues in open Epics:

issueFunction in issuesInEpics("statuscategory != Done")

You can refine the part between parentheses of course to limit the list of Epics to certain projects as well.

Hope this helps!