couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hank Knight <hknight...@gmail.com>
Subject Re: Strange values for "total_rows" and "offset"
Date Tue, 15 Oct 2013 12:56:36 GMT
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