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 kevin.r.coombes@gmail.com
 designates 209.85.216.52 as permitted sender)
Message-ID: <528F6C5B.6060308@gmail.com>
Date: Fri, 22 Nov 2013 09:38:19 -0500
From: Kevin Coombes <kevin.r.coombes@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.1
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: couchdb data structure
References: <em9c399a85-01d1-4a43-be6e-2d2495cbcce6@mesh>
In-Reply-To: <em9c399a85-01d1-4a43-be6e-2d2495cbcce6@mesh>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


On 11/22/2013 9:18 AM, John Norris wrote:
> Hi Jens,
> thanks for this - makes sense.
> To continue on this path, so if I have separate document types, where 
> docTypeA has a reference to docTypeB, can I have a view that returns a 
> docTypeA based on a value within docTypeB object? My feeling from the 
> docs I have seen is "no".
> Also, my view returns a list of key, values. And I can use the eg key 
> parameter to return a particular key, value. I can also use the keys 
> parameter to return more than one particular key. But can I return a 
> document based on more than one field.
> What I mean is if a document type is defined as
> {
>    id: xxxx,
>    fname: fred,
>    lname: smith,
>    dob: 01/01/2001
> }
> The view can emit a key of "doc.fname, doc.lname" but can I search on 
> "fred" and "smith"? I could combine the two and search on "fredsmith" 
> I guess. 
You can define separate "lastname" and "firstname" views, and queries 
would look like

http://yourcouch/yourdb/_design/q/_view/firstname?key="fred"
or
http://yourcouch/yourdb/_design/q/_view/latname?key="smith"

If you are not sure if the first name is "fred" or "frederick", you can 
get them all with a query like

http://yourcouch/yourdb/_design/q/_view/firstname?startkey="fred"&endkey="fredz"


You could also define a view (say 'name') that looks like

function(doc) {
     if(doc.fname) {
         emit(doc.fname, doc._id);
         emit(doc.lname, doc._id);
         emit(doc.fname+' '+doc.lname, doc._id);
         emit(doc.lname+', '+doc.fname, doc._id);
     }
}

and then you could search on first name, last name, or full name into 
the same view.
> But, moving away from a name, it was two towns, then they could be any 
> order eg "london-leeds" or "leeds-london". Again, the could be 
> combined but can a doc be emitted twice eg emit called twice?
Yes; see the above example.

> Sorry this is all a bit confused, and the examples are not great but 
> hopefully the general question is getting over.
> Regards,
> John
>
>