2022-01-20: Query Builder v3 updates

We have updated the Query Builder UI to clearly display the precedence of logical operators (AND, OR, EXCEPT).

Query statements that are connected using AND and EXCEPT operators have equal precedence, whereas query statements connected with OR are run first.

For example, to return a list of customers who purchased SKU1 or SKU2 and have an historical value in sales (CHS) greater than $500, you can use either of these query statements:

1. CHS > $500 AND (SKU = 1 OR SKU = 2)

2. (SKU = 1 OR SKU =2) AND CHS > $500

(Specify CHS from the Customer Attributes category, and SKU from the Product Attributes category.) 

Send us your feedback, questions, and ideas!

Additional updates to Query Builder are coming! Stay tuned, and in the meantime, please provide your feedback, questions, and ideas.