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

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

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.