nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help w/ difficult JQL

JD.Lobue

We have a filter query that we would like to further filter out.

Currently we have a board on a JSW that is using a JSW, filtering out an issuetype, a combination of two custom fields and removing a component and labels. We would like to further filter out all Epics that were not reported by our PO unless they are reported by someone and forecasted to be within the next PI. So.....I know. I know. Complex JQL for board filters are not the best way, and believe me, I will be trying to rid out the waste. In the meantime, can anyone give me some suggestions? Below is the complex query that is currently being used and all that is needed now is the filtering out of the epic only showing if reported by PO or showing by others only if in PI. Thanks ahead of time. All you JQL masters have at it.

project = [JSW] AND issuetype != [IssueType] AND ([CustomField] = [Value] OR [SecondCustomField] = [Value]) AND (component != [ComponentValue] OR component is EMPTY) AND (labels != [Value] OR labels is EMPTY) ORDER BY RANK ASC

Accepted answers

All comments

John Funk

Hi JD - Welcome to the Atlassian Community!

Not sure that I have brain power for the full query right now but have you thought about implementing the board filter you have above? And then assuming that works, adding a quick filter to see if it filters out what you want. That way you could trouble shoot just that last part.

Kavitha Chandrasekaran

Do you want to filter out just Epics not reported by the PO or all issues (from the filtered list by the issuetype which you already have) related to the EPIC not reported by the PO?

Kavitha Chandrasekaran

Section 1: Can exclude issue type EPIC plus any other issue type you intent to exclude

(project = [JSW] AND issuetype != [IssueType] AND ([CustomField] = [Value] OR [SecondCustomField] = [Value]) AND (component != [ComponentValue] OR component is EMPTY) AND (labels != [Value] OR labels is EMPTY) )

Section 2 can include just the EPIC issue type and filter out based on reported being PO or not.

(project = [JSW] AND issuetype = EPIC AND ([CustomField] = [Value] OR [SecondCustomField] = [Value]) AND (component != [ComponentValue] OR component is EMPTY) AND (labels != [Value] OR labels is EMPTY)

AND (reporter = 635f8aaffe5ff375235b158e) OR (reporter != 635f8aaffe5ff375235b158e AND Sprint = 4)))

Kavitha Chandrasekaran

hi @JD.Lobue Hope this helps.

JD.Lobue

I want to filter out only those epics that were not reported by the PO that are scheduled for the first PI, and keep all other issuetypes and epics that were reported by the PO regardless of schedule.

JD.Lobue

I tried above and it only is returning the epics. No other issuetypes are returning.

JD.Lobue

How can we use a quick filter to filter out epics?

JD.Lobue

Any more suggestions.....???

John Funk

Board Settings > Quick Filters

Create a quick filter called Hide Epics. The JQL will be: issuetype != Epic

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud