Looking for help with filter

[Dave]

Hey there, I can't seem to sort out why this filter is still showing me Epic task types from my DJT project. Can anyone advise? Please see the screenshot. 

[Jack Brickey · Accepted solution]

It is all about proper use of (). Try placing "(" right after "OR" and a ")" after "epic)". If you have issues please paste the JQL here and I can edit for you.

[Nic Brough -Adaptavist-]

Without the clarity of () to explain exactly what you want from a query, the computers have to simply read what they're given.  They have no understanding of what you might be asking to see like other humans can.   I think I can see what you really want from this query, but the computers can't.  So they have rules for parsing the "natural language". 

The reason the query isn't doing what you expect is that Jira's rule for parsing is "read each clause and operation left-to-right"

In other words, the first bit before the OR is selecting epics.  The issuetype clause has no impact on the pair of clauses before the OR.

[Purpjesus28]

Try this :) it should do what you are trying it to 

(status in ("In Progress", "In Review", "In Testing", "Move To Production", "Move To UAT", "Pre-Migration Prep") and assignee = current User()) or (project (DJT) AND status in ("In Progress") And issuetype not in (Epic)) ORDER BY status, priority, due