Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

Combining Expressions

Combining Expressions

You can use AND or OR to combine multiple expressions.

For example, the following query uses AND to match all Kodak zoom lens items (based on the value of the Lens System / Type attribute).

FIND Product WHERE AttributeName{Lens System / Type}[en] = 'Zoom lens' AND BrandName[en] = 'Kodak'

The following query uses OR to match all Pentax and Kodak products:

FIND Product WHERE BrandName[en] = 'Pentax' OR BrandName[en] = 'Kodak'

You can use parentheses (the ( and ) characters) to set the order in which expressions are evaluated. Expressions in parentheses are evaluated first. You can nest expression groups.