Default navigation queries allow only one dimension value per dimension.

The following are examples of default navigation queries:

   Red
   Red + France
   Red + France + 1996

In order for a record to be returned for a default query, it must be tagged with all of the dimension values in the query. In other words, a default navigation query is an AND query.

The MDEX Engine also supports more advanced queries that contain multiple dimension values from a single dimension. These values can be used in AND queries or OR queries. For example:

   (Oak AND Berry) + 1996
   Red + (France OR Chile)

The MDEX Engine does not support the use of OR queries across dimensions. For example, a query for France OR Red is not allowed.

See the Oracle Commerce MDEX Engine Developer's Guide for more information about advanced multi-select query options.