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
 sebastiancohnen@googlemail.com designates 209.85.214.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=GgeXEFCWi4QV887NsfciVmwbWC2KOJtJTbbNW+hJcgB7wl0QJYkJQhPwVioPpvJMUL
         50J16VRqtomqa6h90ABDCvWehO6HK64HweCWE4KJYsfVhq0QG2hMV91FzKXrhHkZv1Jd
         f6+M9wATsuwjnj+pq6bVZYLMfNhbqnSVtvFFs=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1081)
Subject: Re: endkey doesn't obey limit parameter and always returns entries
 starting with offset 0
From: Sebastian Cohnen <sebastiancohnen@googlemail.com>
In-Reply-To: <AANLkTik3+m+D4PLNpNwqKivF7EQDx0vSbPsBx8hTK7XT@mail.gmail.com>
Date: Sun, 12 Sep 2010 10:39:41 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <FE69E9F7-0736-47D5-B853-50BCC5BD0938@googlemail.com>
References: <AANLkTik3+m+D4PLNpNwqKivF7EQDx0vSbPsBx8hTK7XT@mail.gmail.com>
To: user@couchdb.apache.org

Hey Henrik,

this does not sound like a bug.

You need to specify a startkey, if you want proper pagination. couch =
streams results from the index from startkey to endkey, but limited to =
the given limit parameter. if you don't provide a startkey, couch will =
stream from the beginning (AFAIK) up to endkey when the limit of results =
is hit (whichever comes first). this is the reason why you will always =
see the first "page" in your application.

I'm not sure if there is an example in the couchdb book or in the wiki, =
but sofa (jchris' blog couchapp) has pagination build in. Maybe you can =
have a look there (http://github.com/jchris/sofa). Pagination is best =
build using startkey and limit.


Best

Sebastian

On 12.09.2010, at 09:06, Henrik Skupin wrote:

> Hi,
>=20
> For my current Couch application I'm using pagination to show only 50
> results per page. To navigate back and forward the endkey vs. startkey
> parameters are used. While startkey in combination with limit is =
working
> fine, endkey doesn't return results for [offset(endkey)-limit,
> offset(endkey)] but for [0, limit]. This makes pagination impossible =
for me
> and looks like to be a bug. An example you can find here:
>=20
> http://mozmill.hskupin.info/general/reports
>=20
> After opening the page click 'Next' twice and check the URL of the
> 'Previous' link before clicking on it. The endkey parameter will not =
be
> obeyed and a click on that link causes the first page to be opened.
>=20
> The code can be found at: http://github.com/whimboo/mozmill-dashboard
>=20
> Is the above problem a known broken behavior and worth filing a bug?
>=20
> Thanks,
> Henrik