With Secondary Indices, users can tag their data with values, and can later query across their tagged data with simple SQL-style queries.
The following query, for example, will select the first 20 keys tagged with country of ‘Germany’ and category of ‘bread’, ‘sausage’, or ‘beer’, sorted by category and name:
FROM food
WHERE country_id='Germany' AND category_id IN ('bread', 'sausage', 'beer')
SORT BY category_id ASC, name_txt ASC
SLICE 1 TO 20
The following query, for example, will select the first 20 keys tagged with country of ‘Germany’ and category of ‘bread’, ‘sausage’, or ‘beer’, sorted by category and name:
FROM food WHERE country_id='Germany' AND category_id IN ('bread', 'sausage', 'beer') SORT BY category_id ASC, name_txt ASC SLICE 1 TO 20