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 th4ngnh0c@gmail.com designates
 74.125.83.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=vjho/t7TqJ8GOD75WR2Mb6cUPdnfjZtHYGBVu13Cbdtg9LiXbSBe2ySi9PMvmEz6Kh
         XA8cdyK/qFnaWVuxdWC6SHHfEYiIJhBWenU44ZlfhPQzCcjBfa2BbySV0bN9xWa0xLEm
         ZyW+XIhMNj/MPlgbexj7wA8G3i43L9mI37+Fs=
MIME-Version: 1.0
Date: Thu, 11 Nov 2010 11:35:12 -0500
Message-ID: <AANLkTinT8VHoa4oDcq4aEfxYNfWUv08ZDh2fYpPms3Qj@mail.gmail.com>
Subject: Join Query View
From: Duc Phan <th4ngnh0c@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=20cf301cc0eadadab30494c98e49

--20cf301cc0eadadab30494c98e49
Content-Type: text/plain; charset=ISO-8859-1

Hello all,
I am fairly new to couchDB and the Map/Reduce framework.
I am having problems creating a join view.

For example:
I have multiple documents in these two formats
First
------------------------------
-------------
Type : Inventory
ID: someID
Name: someName
Location: someLocation
Serial: someSerial
------------------------------------------


Second
-----------------------------------------
Type: Machine
Serial: someSerial
Model: someModel
OS: someOS
RAM: someRAMsize
HD: someHDsize


Here is what I am trying to do...
in SQL > Select ID, Name, Location, Type, Model, OS, RAM, HD from Inventory,
Machine where Inventory.Serial = Machine.Serial
That would join the two tables where the Serials match up.

How would I do that in couchDB where I have multiple documents with Type:
Inventory and Type: Machine
I would like the output to be something like:
{"ID":"someID","Name":"someName","Location":"someLocation","Serial":"someSerial","Model":"someModel","OS":"someOS","RAM":"someRAMsize","HD":"someHDsize"}
for all the machines
I have read couchDB the definitive guide and many blogs but I still haven't
found a way to solve my problem.

My attempt:
Map: function(doc){
if (doc.Type == "Inventory"){
emit ([doc.SERIAL,0],doc);}
else if (doc.Type == "Machine"){
emit([doc.SERIAL,1],doc);}
}

Reduce: ? What should I do here.

Thank you in advance for any suggestions or help.

--20cf301cc0eadadab30494c98e49--