How do I filter with issueLinktype = requires where the issue link is not closed?

Question

I have built a query that will produce a list of instances where the issueLinkType = requires (see below), but I want to only list the instances where the links marked 'requires' that are not closed yet.  Can I use an embedded sub-query (where requires != Closed)?  How do I set this up?

project = MYSTUFF AND status in (Open, "In Progress", "On Hold", "In Definition") AND component = "My Tracker" AND issueLinkType = requires AND "Start Date/Time" > "2020/12/01" AND "Start Date/Time" < "2021/12/01" ORDER BY "Start Date/Time" DESC

Alex Koxaras -Relational- · Accepted Answer

Hi @[deleted]and welcome!

If you mean by "not closed" all unresolved issues, then you can either include in your query the resolution != resolved, to get all the issues which have no resolution.

You can save your existing query as is, and then create a new query with the form:

filter = "my saved query" and resolution != resolved

Either way will work. Hope that helps!

Alex