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 andrey.kouprianov@gmail.com
 designates 209.85.212.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <loom.20121129T184342-319@post.gmane.org>
References: <loom.20121129T184342-319@post.gmane.org>
From: Andrey Kuprianov <andrey.kouprianov@gmail.com>
Date: Fri, 30 Nov 2012 09:33:08 +0800
Message-ID: 
 <CAG+HO1wEmvmfXfdkRow3zqEmHoc2uB3aJP9jxPcyN+FP+g2T+A@mail.gmail.com>
Subject: Re: Multiple key value query
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=bcaec501c0ccf7e45004cfac62c3

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

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
>
>

--bcaec501c0ccf7e45004cfac62c3--