Hi all, I’m constructing an advanced filter and not sure how to introduce nested “and/or” conditionals in the advanced expression. What I’m trying to do is like the following: … something = something else AND ( ( thing’s attribute 1 = xx AND thing’s attribute 2 = yy ) OR ( thing’s attrib…

The formatting was not so great there after whitespace got scrubbed (sorry, first post). Better seen more concisely as: (thing’s attribute 1 = xx AND thing’s attribute 2 = yy) OR (thing’s attribute 2 = zz AND thing’s attribute 3 = aa)

Excellent post, thanks Keith. Was searching and couldn’t find that one. So do you know how you might solve an (A and B) or (C and D) expression left to right? I have a feeling it might involve a different trick.

Well, you’d basically have to precompute C AND D, like create a boolean state somewhere (let’s call it E) and then in your workflow, right before where you are trying to use (A and B) or (C and D), set that state to C AND D. And then your condition in the next step becomes A AND B OR E. (And yes th…

Filtering on nested and/or conditionals

Need help Database

keith December 30, 2019, 9:04pm 3

They get evaluated left to right.

More detail: How to combine AND and OR operators? ...Continued

Topic		Replies	Views
How to combine AND and OR operators? ...Continued Need help	8	1948	April 24, 2019
Possible to use "and" "or" together in "only when" condition? Need help	10	147	October 9, 2025
How to combine AND and OR operators? Need help	11	3223	October 28, 2018
And/or in conditionals Questions	3	907	January 9, 2023
What order are "and" & "or" evaluated in expressions? Questions	3	1727	August 1, 2017

Filtering on nested and/or conditionals

Related topics