Elastic Path Production Tools

Specifying the First Match

Specifying the First Match

You can specify the position of the first match to return within the results by adding START <number>, where <number> is the position of the first match you want to return. For example, the following query returns the first ten matches starting at the twentieth match:

FIND Product WHERE BrandName[en] = 'Pentax' LIMIT 10 START 20
      
Note:

Currently, it is not possible to sort results. This is primarily used in search queries executed by the Import-Export tool to split result sets into more manageable "chunks". For example, the following query returns 274 matches for the Snap It Up master catalog:

FIND Product WHERE BrandName[en] = 'Pentax'

You can split those matches into three separate result sets by executing the following three queries:

FIND Product WHERE BrandName[en] = 'Pentax' LIMIT 100
FIND Product WHERE BrandName[en] = 'Pentax' START 101 LIMIT 100
FIND Product WHERE BrandName[en] = 'Pentax' START 201

The first query returns matches 1 to 100. The second returns 101 to 200. The third returns from 201 to the last match (274).