Track Epics with Specific child issues

[Khara Lynn Barreto Fernando]

I tried to create a filter:

issuetype = Epic AND issueFunction in issueFieldMatch("", "issuetype in (Planning, Design)")

Got this response:

The "issueFieldMatch" JQL function provided by "Adaptavist Scriptrunner" for Jira Server works differently in Jira Cloud. Run it directly in "Enhanced Search" instead. See the documentation for more details: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions

but of course that link is a 404 dead page

I want to create views that help me understand which Epics have specific child issue types, and conversely, which Epics do not have any child issues of those types.

Here are my two main goals:

1. Tracking Epics with Specific Child Issue Types:
   • How can I set up a filter or a query to identify Epics that have child issues of certain types? I'd like to keep an eye on these Epics as they progress through various phases.
2. Identifying Epics without Specific Child Issue Types:
   • Conversely, how can I create a view that shows Epics that do not have any child issues of specific types? This would help me identify Epics that may need additional work in those areas.

I'd greatly appreciate any insights, tips, or JQL queries that can help me achieve these tracking objectives. 

Thank you in advance for your assistance!

[Trudy Claspill]

Hello @Khara Lynn Barreto Fernando 

Welcome to the Atlassian community.

This link is for the page for the JQL Functions information for ScriptRunner for Jira Cloud:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

In Jira Cloud most of the ScriptRunner JQL functions cannot be used directly in the Advanced Search/View All Issues screen. Instead you have to use a new interface called ScriptRunner Enhanced Search to create the filters that use those functions. For more info about that interface you can refer to

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search

You can build the filters and save them there, as well as execute them there. You can also execute those saved filters in the View All Issues screen using this JQL: 

filter ="Name of your saved filter"

As to the queries you are trying to build:

To find Epics that have at least one child issues of certain types use the epicsOf function

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions#epicsof

issueFunction in epicsOf("issueType in (X, Y, Z)")

I'm still working out how to do the second filter. It is not as simple as changing the above to "issueType not in ()". That would get you all the Epics that had a child issue that is not one of the specified types, but that is not the same as saying the Epics don't have any child issues of the specified types.

[Khara Lynn Barreto Fernando]

Hey trudy thanks so much for this, but I realize that I can't use scriptrunner. So I'll have to ask a different question. Leaving this up however to help others