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

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).