couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <rnew...@apache.org>
Subject Re: Strange values for "total_rows" and "offset"
Date Tue, 15 Oct 2013 13:19:35 GMT

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
View raw message