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 cscott@gmail.com designates
 209.85.210.177 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=HG5Ldu3nw8zPOGcGUdN4jet7On7hzwVyiZHIwLx8Jq1L61MRN/r1No/hLJh4/gyK2t
         uVbs37RFm0/y/FGr16HZuUwSYX0+N3cTyju3flYhXqpRdi6lVQcOuW8XxPa3ATuOw6PR
         iSb8JSeIBbs8wBh0rdNDfTY9U0Lpjm4ayO2NM=
MIME-Version: 1.0
Date: Thu, 4 Mar 2010 16:28:07 -0800
Message-ID: <9e4ef4d1003041628o3cbd4308yf5c907dcaafb06cf@mail.gmail.com>
Subject: Views and AND/OR-like Functionality
From: Cy Scott <cscott@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00163623ac9222844b048102ca9c

--00163623ac9222844b048102ca9c
Content-Type: text/plain; charset=ISO-8859-1

Just getting started with CouchDB (loving it btw) and am wrapping my brain
around the views. I've seen mention that CouchDB doesn't really handle
ANDing or ORing a la SQL, but is there some way to emulate it?

Here's an example scenario. Say I have documents for different sweaters in
the form of (with _id, _rev, etc.):

{
  "color": "Red", "size": 4, "price": 8.00

}


My data has sweaters of different colors, sizes and prices. The
problem I'm having is when I want to get data for different
permutations like: ALL blue and red sweaters that are size 5 or ANY
green sweaters under $30. I've tried complex keys [doc.color,
doc.size, doc.price] but don't know if this is the right direction.


My simple map function looks like function(doc) { if(doc)
emit([doc.color, doc.size, doc.price], null); };


| key               | value
|----------------------------
|["Blue",  5, 15]  | null
|["Green", 4, 25]  | null
|["Red", 5, 10] | null


Anyone have any thoughts on how to best implement this type of
scenario? Or links to some info, previous thread that might have
covered this. Appreciate any and all help!

--00163623ac9222844b048102ca9c--