Hello,
I have query for a kanban board:
project in (ABC) AND (team ~ Ducks) AND type in (Epic, Sub-task) AND (resolution is EMPTY OR resolution not in ("Won't Do", Obsolete)) ORDER BY Rank ASC
I also have several quick filters that filter out epics that are in progress, but there are no issues, epic that is in progress but has stories that are closed, or an epic that is not linked to an epic portfolio.
How would I combine the query above with this query below for a quick filter?
type = Epic AND (issueFunction not in hasLinks("Structure Parent") or issueFunction not in linkedIssuesOf("type = 'Portfolio EPIC'")) AND status not in (closed, done)
My goal is to produce a query for filter gadget on a dashboard.
Thanks
Paul
Hi @paul
If your goal is to combine the two filters, I believe the following should work:
project in (ABC) AND (team ~ Ducks) AND type = Epic AND (resolution is EMPTY OR resolution not in ("Won't Do", Obsolete)) AND (issueFunction not in hasLinks("Structure Parent") or issueFunction not in linkedIssuesOf("type = 'Portfolio EPIC'")) AND status not in (closed, done) ORDER BY Rank ASC
Try this on the Jira issue navigator to verify if this returns your expected results.
Hi Mohamed, the combination did not return any records.
The query for the kanban board returns about 60 records. Note the project and team names are changed for privacy reasons.
project in (ABC) AND (team ~ Ducks) AND type in (Epic, Sub-task) AND (resolution is EMPTY OR resolution not in ("Won't Do", Obsolete)) ORDER BY Rank ASC
When I run the quick filter on the board, there are 2 records return:
type = Epic AND (issueFunction not in hasLinks("Structure Parent") or issueFunction not in linkedIssuesOf("type = 'Portfolio EPIC'")) AND status not in (closed, done)
Do you have other ideas on how to make the combination query return the 2 records?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.