Filter 'Epics' with all issues in epic closed except 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 complex structures with sub-queries.

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 have (story, bugs, spikes) in status=CLOSED
except for a story with Title-Summary with the name "MyGoal*" (MyGoal_1, MyGoal_10, etc...)

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

issuefunction in issuesInEpics("issuetype in (story, bug, spike) AND status = Closed OR issuetype = story AND summary ~ "MyGoal*" AND status != Closed")

How Can I resolve to locate EPICS with only a story in "Issues in Epic" not closed and an exact title summary if all rest of issues in epic are closed?

Richard Kallas_x4uc9r · Answer

I was thought of another possibility for my 'Quick filter', but I don't know to manage SUB-QUERIES inside of "issuefunction in issuesInEpics". Maybe I can get a consult via "Assignee"

Firstly, The sintaxis "issuefunction in issuesInEpics" is a function to manage issues inside of a Epic?

So, if I need to search EPICS that does not contain a 'UserStory' assigned to a person? Is it possible?
What syntaxis I must use?
I try this one, but it has an error:

project = NameOdProject AND issuetype = Epic AND status != Closed AND issueFunction in epicsOf("issuetype = Story AND assignee in not ("Email@User1", "Email@User2", "Email@User3"), 'has epic")

Rahul_RVS · Answer

Hi @Richard Kallas

If you would be interested in a mktplace app, to visualize the hierarchy based on the issue links, we have created an add-on to track the issue links and issue progress at each level and for cross project links as well.

Pls try it out.

Agile Tools - Epic Tree, Links Tree and Time in Status

Key features of Links Hierarchy:

* Hierarchy upto 10 levels deep
* Progress % on "remaining estimate" or "original estimates"
* Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
* Rolled up percentage completion at all levels
* Ability to add/remove the columns on the report

Disclaimer: I work for RVS, the vendor for this app, and I am one of the developers in the team

Richard Kallas_x4uc9r · Answer

Hi Fabian and thanks you for your welcome.
Do you have some examples of links hierarchy?
I don't know this concept. :-)