Syntax rules that apply to all Filter line expressions:
By default, all equations are solved from left to right, with enclosed sub-operations evaluated first.
The AND operator retrieves data that meets both conditions. For example, if you query customers, and filter State to “Florida” AND Item Type to “Modem,” the data retrieved would apply only to customers buying modems in Florida, not to modems bought in Minnesota or keyboards bought in Florida.
The OR operator retrieves data that satisfies either of two conditions. For example, if you filter State to “Florida” OR Item Type to “Modem,” the data retrieved would include Florida customers and any customers purchasing modems. It would not include customers purchasing keyboards (unless they lived in Florida), or customers in Minnesota (unless they bought modems).
Suboperations allow you to override the default evaluation order, and may be required for certain operations involving both AND and OR operators.