Details
-
Improvement
-
Resolution: Unresolved
-
Critical
-
feature-backlog
Description
Is there any built in function in N1QL which is equivalent of SQL_CALC_FOUND_ROWS AND FOUND_ROWS() in MySQL to use with LIMIT , OFFSET for prepare Pager purposes?
If no what is the best workaround to achieve same result rather than execute additional N1QL query mentioned below
SELECT COUNT(id) FROM mybucket WHERE <same condition that get first result set>