JQL Filter on Problem Records with ALL linked Spikes done

Question

Is there any way for filtering to get e.g.

- Problem Records in status estimate

- all linked spikes with "analyzes" are in state "done"

I tried with "linkedissuesOf" but there I always get results like e.g.

Problem Records with 4 Spikes linked, 2 of the spikes in state done and 2 in state open.

I only want to see Problem Records with ALL linked Spikes done.

Marc -Devoteam- · Answer

Hi @Andreas H

If these open spikes are linked to a problem with also a linked close spike they are shown.

You are looking foor issues with type problem that has a linked spike that is closed and the linktype is analyze

JQL searching for links, will still show any other linked issues to the main issue type searched.

Even if that is another issutype or a non closed.

the search first connects via the linktype that is analyze, sa all problem with an linked issue , using the linkype analyze are found, then it removes the problem issues where there is no Spike and not closed using this isuse type.

Andreas H_ar6cc6 · Answer

Hi @Marc -Devoteam-

I would need it the other way around. 
I need a filter to show Problem Records, where all linked Spikes are in the status "done". 
My current filter shows Problem Records with e.g. 5 linked spikes, 2 of them done and 3 of them in status in work. But these I don't wanna see.

Marc -Devoteam- · Answer

Hi @Andreas H

If I use a similar jql in my instance, all is ok.

JQL:

issuetype = story AND issueFunction in linkedIssuesOf ("issuetype = bug AND status = done", "relates to")

Can you check the open Spike, you see. Do they still have a resolution set, so have they been moved from a "Done" state back to a non "Done" state, but the resolution has not been cleared on this transition?