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 acunningham@integrics.com
 designates 194.145.196.78 as permitted sender)
Message-ID: <4D2C0B5E.1050706@integrics.com>
Date: Tue, 11 Jan 2011 11:48:46 +0400
From: Alistair Cunningham <acunningham@integrics.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.2.13) Gecko/20101208 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Views with variable parameters
References: <4D2BFFBF.7000303@integrics.com>
 <AANLkTikJrFi-QPwMaVWNu4tvyevYhTuivh6MSP5LSi9g@mail.gmail.com>
In-Reply-To: <AANLkTikJrFi-QPwMaVWNu4tvyevYhTuivh6MSP5LSi9g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Thank you, that's perfect!

Alistair Cunningham
+1 888 468 3111
+44 20 799 39 799
http://integrics.com/

On 11/01/11 11:11, kowsik wrote:
> In your design/view, say 'blah/foo', do this:
>
> emit([ doc.field1, doc.field2 ], null)
>
> And when you query:
>
> GET /db/_design/blah/_view/foo?key=["abc","def"]
>
> Hope that helps,
>
> K.
> ---
> http://www.pcapr.net
> http://twitter.com
> http://labs.mudynamics.com
>
> On Mon, Jan 10, 2011 at 10:59 PM, Alistair Cunningham
> <acunningham@integrics.com>  wrote:
>> Hello all,
>>
>> Is there an efficient way to implement a view that does the equivalent of
>> this SQL?
>>
>> select * from documents where field1='abc' and field2='def';
>>
>> where 'abc' and 'def' are different for every query? It needs to be fast and
>> scalable on large data sets (millions of documents).
>>
>> --
>> Alistair Cunningham
>> +1 888 468 3111
>> +44 20 799 39 799
>> http://integrics.com/
>>