Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of gs@redcometlabs.com
 designates 74.125.82.170 as permitted sender)
From: Garren Smith <garren@apache.org>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_21FF711E-B956-42DC-860F-33C107D6220B"
Message-Id: <6F72805A-F8AA-4C88-97E9-239346FDC40E@apache.org>
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: Strange values for "total_rows" and "offset"
Date: Tue, 15 Oct 2013 15:24:33 +0200
References: 
 <CAMAefevMbKQxoORqzZvoY4qYdws3M0McpHw0v90BXLOtxz+EsA@mail.gmail.com>
 <305D22F7-FD26-4142-B749-34A52A2AA6CC@apache.org>
 <CAMAefeu0Wn8qE6SwdfZHC1mDtHoKdMEuZTWFH8s2pZ4LzbzsNg@mail.gmail.com>
 <2B8ADCE1-6AA1-4674-AB46-F62B28CFCFC4@apache.org>
To: user@couchdb.apache.org
In-Reply-To: <2B8ADCE1-6AA1-4674-AB46-F62B28CFCFC4@apache.org>

--Apple-Mail=_21FF711E-B956-42DC-860F-33C107D6220B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

Hi Hank,

Here is some documentation on how to do pagination with Couchdb.=20
=
http://docs.couchdb.org/en/latest/couchapp/views/pagination.html?highlight=
=3Dpaginate

Cheers
Garren

On 15 Oct 2013, at 3:19 PM, Robert Newson <rnewson@apache.org> wrote:

>=20
> Sadly not.
>=20
> On 15 Oct 2013, at 13:56, Hank Knight <hknight555@gmail.com> wrote:
>=20
>> I need the total rows matching my query so I can do proper pagination =
based
>> on a query.  Is this possible?
>>=20
>>=20
>> On Tue, Oct 15, 2013 at 9:42 AM, Robert Newson <rnewson@apache.org> =
wrote:
>>=20
>>> total_rows is the total number of rows in the view, not that match =
your
>>> query.
>>>=20
>>> B.
>>>=20
>>> On 15 Oct 2013, at 13:38, Hank Knight <hknight555@gmail.com> wrote:
>>>=20
>>>> There are only 10 matching results where the key is "GOLD":
>>>> http://example.com/abc/_design/iws/_view/q?key=3D%GOLD%22
>>>>=20
>>>> However the first line of the response is this:
>>>>=20
>>>> {"total_rows":52340,"offset":218,"rows":[
>>>>=20
>>>> Why doesn't it say this?
>>>>=20
>>>> {"total_rows":10,"offset":0,"rows":[
>>>>=20
>>>> The problem is that when I limit results like this:
>>>>=20
>>>> =
http://example.com/abc/_design/iws/_view/q?key=3D%GOLD%22&limit=3D5&skip=3D=
0
>>>>=20
>>>> I cannot tell from the response if that response includes all =
matches or
>>>> only the first five.
>>>=20
>>>=20
>=20


--Apple-Mail=_21FF711E-B956-42DC-860F-33C107D6220B--