Elastic Path Production Tools

Limiting the Result Set Size

Limiting the Result Set Size

You can limit the number of results returned by adding LIMIT <number>, where <number> specifies the maximum number of items to include in the results. For example, to return the first ten Pentax products, execute the following:

FIND Product WHERE BrandName[en] = 'Pentax' LIMIT 10