I have a report that uses SQL “and” between conditions and SQL “or” between clauses. I know that I can choose to use “or” between conditions, which flips the “or” to “and” between the clauses. What I want to do is to mix “and” and “or” between conditions. For example:
Content Visibility is Visible
and
Content Source Severity is Critical
or is Important
or is High
or Content Category is Critical Updates
or is Security Hotfix
or is Security Hotfix
and
rest of and conditions continues here . . .
Is this possible?