Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of
 andrew.stuart@supercoders.com.au designates 50.23.246.234 as permitted
 sender)
Message-Id: <6F4EB410-E2A4-4228-8F3D-718A5497C7EE@supercoders.com.au>
From: "Andrew Stuart (SuperCoders)" <andrew.stuart@supercoders.com.au>
To: user@couchdb.apache.org
In-Reply-To: <4D929FDC.6040805@gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v936)
Subject: Re: Recommendations for how to do faceted search in CouchDB
Date: Wed, 30 Mar 2011 14:23:35 +1100
References: <4EA8CEDD-16B5-42D5-ABF3-846164CFC4D4@supercoders.com.au>
 <4D929FDC.6040805@gmail.com>

thanks Patrick

A question - does this technique also work if for example a job  
appears in multiple locations (melbourne & sydney), or it appears in  
multiple categories i.e. developers/software engineers/web programmers

thanks

andrew


On 30/03/2011, at 2:13 PM, Patrick Barnes wrote:

You can do that with a single view:

In the map, emit for each field key [fieldname,fieldvalue] and value  
null.
In the reduce, set it to '_count' (instead of a js function) to use  
the fast built-in reduce.

Then you can query that view with  
startkey=[fieldname]&endkey=[fieldname,{}]&group=true to see all the  
values in that field.

You don't really need _count, but that might be useful if you wanted  
to have some minimum of how many times a term is used before you  
include it.

-Patrick

On 30/03/2011 1:50 PM, Andrew Stuart (SuperCoders) wrote:
> hi folks
>
> What's the best way to do facted search in CouchDB?
>
> For example consider a jobs website where the user selects from  
> dropdown
> lists to narrow the search location/industry/job title i.e.  
> melbourne/IT
> industry/software engineer or sydney/accounting/bookkeeper
>
> It doesn't seem practical to create a view for every combination of  
> the
> dropdown lists.
>
> any suggestions as to the best way to do this?
>
> thanks
>
-- 
Message  protected by MailGuard: e-mail anti-virus, anti-spam and  
content filtering.http://www.mailguard.com.au/mg
Click here to report this message as spam:
https://login.mailguard.com.au/report/1C0dI02ork/6l9Om021I5Tc7F2B3vVGlU/0