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

[JD.Lobue]

Any more suggestions.....???

[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) )

OR

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 tried above and it only is returning the epics. No other issuetypes are returning.

[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? 

[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.

[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.

[JD.Lobue]

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

[John Funk]

Board Settings > Quick Filters

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