Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: Nils Breunese <N.Breunese@vpro.nl>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Date: Sat, 2 Apr 2011 08:44:24 +0200
Subject: RE: Need to get total rows of startkey/endkey range for paging
Thread-Topic: Need to get total rows of startkey/endkey range for paging
Thread-Index: Acvw9tgXwZKvpcrUSZiCATh9vgZiVgACo/Kk
Message-ID: 
 <A9DC438D6CAFFF4BBB299581444408810120423FF4EC@VS-EX-01.intra.vpro.nl>
References: <903CCA92-4022-4ED5-A540-747E4ACCFA58@supercoders.com.au>
In-Reply-To: <903CCA92-4022-4ED5-A540-747E4ACCFA58@supercoders.com.au>
Accept-Language: nl-NL
Content-Language: nl-NL
acceptlanguage: nl-NL
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

If you set the reduce function of your view to '_count' you will get the nu=
mber of items. Query with ?reduce=3Dfalse if you want to get the items inst=
ead of just the count.

See http://wiki.apache.org/couchdb/Built-In_Reduce_Functions for more info =
on built-in reduce functions.

Nils.
________________________________________
Van: Andrew Stuart (SuperCoders) [andrew.stuart@supercoders.com.au]
Verzonden: zaterdag 2 april 2011 7:27
Aan: user@couchdb.apache.org
Onderwerp: Need to get total rows of startkey/endkey range for paging

Hey there folks

I am issuing a query to a view which uses startkey and endkey to
constrain the range of values to be retrieved from the view.  Within
this I am using skip and limit to page through the results.

The problem is that I need the count of the number of total rows, not
of the view, but of the range defined by startkey and endkey.

This is needed because I am putting the data into a paging grid, and
the paging grid needs to know the total rows so it knows how big to
make the grid and so it knows where the bottom is.

If you are interested here is a sample query:

http://192.168.1.108/couchdb/test/_design/blah/_view/by_surname2?startkey=
=3D%22s%22&endkey=3D%22s%E9%A6%99%22&_dc=3D1301721696775&page=3D4&skip=3D90=
0&limit=3D300

Views do of course return the total number of items in the view, but I
need not the total items in the view but the total items in the
startkey/endkey range.

Can anyone suggest if this is possible?

thanks
------------------------------------------------------------------------
 VPRO   www.vpro.nl
------------------------------------------------------------------------