Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of rgabo@rgabostyle.com designates
 209.85.214.52 as permitted sender)
Sender: Gabor Ratky <rgabo@rgabostyle.com>
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1084)
Subject: Re: how to get documents by two or more keys?
From: Gabor Ratky <gabor@secretsaucepartners.com>
In-Reply-To: 
 <A9DC438D6CAFFF4BBB299581444408810120423FF499@VS-EX-01.intra.vpro.nl>
Date: Tue, 29 Mar 2011 19:06:26 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <7FC4497E-BF26-42DF-872D-3103ED73F3BD@secretsaucepartners.com>
References: <AANLkTinAhu3Vpnn9Pp7VODJNWib88D-OMkxsAcSe8jpe@mail.gmail.com>
 <A9DC438D6CAFFF4BBB299581444408810120423FF499@VS-EX-01.intra.vpro.nl>
To: user@couchdb.apache.org

The only thing to add is that the view indexes are sorted by your =
(possibly complex) keys. You always retrieve a contiguous portion of the =
view by either using just ?key=3D or both startkey and endkey.

Depending on the actual data you want to filter / sort / aggregate by, =
you can always come up with 'smart' complex keys where the data you need =
ends up together, one query away.

An example would be to retrieve a single user's posts from 2011 =
Feburary. If your keys contain [username, date_posted] and your dates =
strings sort chronologically, you can easily query for all posts posted =
by a single user in a timeframe: ?startkey=3D["nils", =
"2011-02-01"]&endkey=3D["nils","2011-02-28"]

If instead, you would also want ALL posts from february from all users, =
you would index by having the date come first, so =
?startkey=3D["2011-02-01"]&endkey=3D["2011-02-28"] yields exactly what =
you want.

On Mar 29, 2011, at 8:25 AM, Nils Breunese wrote:

> Keys can be so called 'complex' keys. You could emit [username, tag] =
as the key for your view entries and then request =
/_design/designname/_view/by_username_and_tag?key=3D["username","tag"] =
to do the lookup.
>=20
> Nils.
> ________________________________________
> Van: bryan rasmussen [rasmussen.bryan@gmail.com]
> Verzonden: dinsdag 29 maart 2011 8:03
> Aan: user@couchdb.apache.org
> Onderwerp: how to get documents by two or more keys?
>=20
> As per the subject - most of my requests can be done with simple views
> but I have some cases where I will want to return for multiple keys -
> for example where I want to return documents for a username where
> there is a particular tag value?
>=20
> Thanks,
> Bryan Rasmussen
> =
------------------------------------------------------------------------
> VPRO   www.vpro.nl
> =
------------------------------------------------------------------------