Couchbase alternative for SQL query with WHERE, ORDER and LIMIT
we have problem with simple SQL translation of this SQL query to Couchbase View/Query mechanism:
SELECT name FROM user WHERE age=20 AND email="firstname.lastname@example.org" ORDER BY time LIMIT 10;
Is it possible to query Couchbase server for result with specific properties (WHERE), order it by time (ORDER BY) and get only limited result set (LIMIT)?
The specific properties are usually different for each query, so this is not possible to place it in the MAP function (=> many views).
Any solution for this problem will be highly appreciated.