JQL Filter on Problem Records with ALL linked Spikes done

[Andreas Hauser]

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]

HI @Andreas H 

Welcome to the community.

What is your current JQL look like?

Example JQL

issuetype = Problem AND issueFunction in linkedIssuesOf("issuetype = Spike AND status = done", "analyze")

[Andreas Hauser]

@Marc - Devoteam this is the query I tired already

[Marc - Devoteam]

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?

[Andreas Hauser]

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]

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.