incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Garren Smith <gar...@apache.org>
Subject Re: Strange values for "total_rows" and "offset"
Date Tue, 15 Oct 2013 13:24:33 GMT
Hi Hank,

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

Cheers
Garren

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

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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message