To implement pagination in Couchbase Server, I added LIMIT and OFFSET in the original subquery. i.e.
select * from bucket where docType=“searchCiteria” LIMIT= OFFESET=
But I also want total number of records. I couldn’t find a way to do these 2 operations in one go. So I had to hit couchbase 2 times.
Is there any way to do that in 1 go?