N1QL query for document + count

[famer1790]

I found this earlier reply, that that works for me.

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…