N1QL query for document + count

[famer1790]

Can I create a single N1QL query that returns the documents as well the count of documents ?

How efficient it would be compared to issuing separate queries for each ?

[vsr1]

COUNT is aggregate. So you can’t return the documents with count unless you use ARRAY_AGG(), which can be memory consuming.

You can use resultCount as count if you are not using pagination.
OR do separate queries.

[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…