Quick filter and the AND condition in SQL

Question

I want to set up a quick filter that excludes issues of a certain type (named "SendCodeasLetter") if they have a certain status (named "ToCheck") and haven't been updated for more than 24 hours.

The SQL looks like this:

issuetype in (Information, Rectification, DataPortability, Generic, Deletion) AND status in (Open, "In Progress", Reopened, Resolved, Closed, Done, Draft, Published, Archived, "To Be Sent", Preparation, InputCheck, DataCollection, DataVerification, Idle, GracePeriod, Deletion, PreNotification, PostNotification, DocumentCreation, DataChanges) AND updated <= -24h

The problem ist that it also excludes some issues of other types (but not all of them). Where is my mistake?

Any help is much appreciated!

unknown · Answer

@Thomas Schlegel That is more elegant, thank you! It does lead to the same result, though. I have 5-6 issues of various types that are not shown in my board after I activate the quick filter. They aren't the "SendCodeasLetter"- issue type (but in the Status "To Check" and were last update more than 24 hours ago) and aren't shown after activating the filter. I do not understand it because we are using "AND" and it behaves like "OR".

Thomas Schlegel · Answer

Hi @[deleted],

have you tried:

issuetype != SendCodeasLetter and status != ToCheck and updated <=-24h