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 pawelstawicki@gmail.com
 designates 209.85.219.216 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type
         :content-transfer-encoding;
        b=pOxBKnrBKTLUssf4wf4w8cTTQq8ucv7Htf9rd85q01iva0tnYW9rl34GP7sZNBPkUO
         /5AxbQW1WtA7gFK10x3FXFsyC8ulpHbx8/n8oCOVp61LdtiDLLpYHaKnyASztrKN2L60
         EX7cOGCpqaVWOpkt4IbojLsiMsdOcomubSWwU=
MIME-Version: 1.0
From: =?UTF-8?Q?Pawe=C5=82_Stawicki?= <pawelstawicki@gmail.com>
Date: Sat, 12 Dec 2009 21:38:49 +0100
Message-ID: <6adfa88d0912121238p3d31e20bn710d23357f80656e@mail.gmail.com>
Subject: How to make equivalent of WHERE on JOINed table in CouchDB?
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Crossposting from stackoverflow.com.

Assume we have two kind of documents in CouchDB. Person and Car:

Person:
_id
firstname
surname
position
salary

Car:
_id
person_id
reg_number
brand
So there is one to many relationship. One person can have many cars.

I can construct map function to get every person and his/her car next
to each other. In such case key is array [person.id, 0] and
[car.person_id, 1].

What I can't do, is limiting this view to owners of specific brand
only, e.g. if I need salaries of owners of Ferrari. So set of
documents (persons) is limited by related documents (cars). How can I
do it?

Best regards
--
Pawe=C5=82 Stawicki
http://pawelstawicki.blogspot.com
http://szczecin.jug.pl
http://www.java4people.com