Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CAG+HO1wEmvmfXfdkRow3zqEmHoc2uB3aJP9jxPcyN+FP+g2T+A@mail.gmail.com>
References: <loom.20121129T184342-319@post.gmane.org>
 <CAG+HO1wEmvmfXfdkRow3zqEmHoc2uB3aJP9jxPcyN+FP+g2T+A@mail.gmail.com>
From: Mark Hahn <mark@hahnca.com>
Date: Thu, 29 Nov 2012 17:47:13 -0800
Message-ID: 
 <CACrj35E2KSoxJ0kLn+Oijj_DFznbdm0bH92yr+Z1SMy8TYR6Ow@mail.gmail.com>
Subject: Re: Multiple key value query
To: user <user@couchdb.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

>  Another easy, but very straightforward way would be to do query 3 times

I had a lot of trouble when switching from sql to nosql feeling guilty
when doing multiple requests.  I've gotten over that now.  Doing 3
fast simple requests is little to no worse than doing an sql query.
This assumes a local DB which is all I've used so far.

On Thu, Nov 29, 2012 at 5:33 PM, Andrey Kuprianov
<andrey.kouprianov@gmail.com> wrote:
> HI Bill,
>
> That would be very difficult to do in one shot. You are basically looking
> for a way to use multiple startkey-endkey pairs, which is not yet available
> in CouchDB.
>
> Easiest way would be to install Lucene or ElasticSearch on top of CouchDB (
> http://wiki.apache.org/couchdb/Full_text_search). That will widen your
> querying capabilities big time. Another easy, but very straightforward way
> would be to do query 3 times for each location and then combine results
> programmatically.
>
>   Andrey
>
>
>
>
> On Fri, Nov 30, 2012 at 1:56 AM, Bill <bill.foshay@noteandgo.com> wrote:
>
>> Hi,
>>
>> I'm newer to couchdb and having some trouble figuring out how to do a query
>> with multiple key values, including a date range. I have a map function
>> like
>> the following
>>
>> function(doc) {
>>   if(doc.type == "Article") {
>>     emit([doc.location, doc.release_date], doc)
>>   }
>> }
>>
>> I'm wondering if it's possible to do a query similar to either of the
>> following
>> sql queries
>>
>> select * from myView
>> where location in ('MD', 'NY', 'VA') and
>> release_date > '2012-11-01' and release_date < '2012-12-01'
>>
>> OR
>>
>> select * from myView
>> where (location='MD' or location='NY' or location='VA') and
>> (release_date > '2012-11-01' and release_date < '2012-12-01')
>>
>> Thanks for any help you can provide!
>>
>> Bill
>>
>>