N1QL and Total Record Count for Paging

[vsr1]

The totoal counts will not available until you process all possible records. That will be waste of resources.
Application should do two separate queries first do count and then do pagination.

Can not get total result count in a paginated query

Hi, I have a query that has pagination with LIMIT and OFFSET. But the problem is, I can not set the COUNT of overall result in a new field called “total” avoiding LIMIT and OFFSET I want this { “total”: // total number of results or rows avoiding limit and offset “results”: [ // this contains the final result rows with limit and offset ] } for example, the query for “results” will be like this: SELECT results FROM test as results where results.user_id = “4545” LIMIT 5 OFFSET 0 This wil…