Filter 'Epics' where doesn't exist a story with a determinate title summary.

Question

I need help to get a 'JQL query' in a 'quick filter' of a Kamban board where I manage epics.
I don't have experience in 'JQL query' to develop some structures.

I attach an image with some explication about what I'm searching for.

What do I need?
Quick filter that only shows the epics that haven't a story called "MyGoal*" (MyGoal_1, MyGoal_10, etc...)
This way, I can detect them and create an "Issue in Epic" with that given name.

I think that it need this query: issuefunction in issuesInEpics
BUT I don't know to resolve it.

issuefunction in issuesInEpics("issuetype = story AND summary ! ~ "MyGoal*")

How can I solve to locate EPICS in which within "Epic Issues" there is no story with a default name ["MyGoal*"]?

Image:

Richard Kallas_x4uc9r · Answer

Well, there is differences.
In the other case all issues (story, bugs, spikes) must be closed except a story with determinate words in the title.

In this post, the goal is to detect epics where doesn't exist a STORY with determinate words in the title.

So, is it possible to use"issuefunction in issuesInEpics" to localize epics that do not contain an issue with determinate words in the title?

Trudy P Claspill · Answer

This post appears to be a duplicate of this other post:

https://community.atlassian.com/t5/Jira-Software-questions/Filter-Epics-with-all-issues-in-epic-closed-except-a-story-with/qaq-p/1967401