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 jjfutbol@gmail.com designates
 209.85.216.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=k5KtCb4mNh0ssqhg+71fV/dwj32WowN8t13wNdpljlv7vXqu5Hjt5087TNUPmWPOuK
         4kyaC7sNfSKd1vtE/c8u9qhCl9zmVMAHCXh4TEgsDza5gjpWuVYXKSOcNxIaGbPApMx1
         WJ6lGRWX8/jaegbz/QEuVvixpjSOHg+MJNrC0=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1082)
Subject: Re: Help With map function
From: Javier Julio <jjfutbol@gmail.com>
In-Reply-To: <2BB3938D-F3E1-4A8D-9A03-01C4401552AC@gmail.com>
Date: Tue, 22 Feb 2011 21:06:20 -0500
Content-Transfer-Encoding: quoted-printable
Message-Id: <D0010D5C-362A-4D70-8CDD-AAACDE9E3BBD@gmail.com>
References: <28D2E88E-D082-47F0-91BE-D6902CAFD10A@GMAIL.COM>
 <C6AF2CB1-A1C0-4E94-ADC6-6158A3C3FE02@gmail.com>
 <2BB3938D-F3E1-4A8D-9A03-01C4401552AC@gmail.com>
To: user@couchdb.apache.org

Paul, thanks for confirming. Can you elaborate on "the non-wildcard =
selection criteria as a leading prefix"? What does that mean?

So to handle an AND/OR statement would best be or perhaps only way to do =
with multiple views? So since Andrey wanted to support "brand and =
category" or "brand or category" he would need 3 views right?

One for item, brand and category, second for item and brand, and the =
third for item and category?

On Feb 22, 2011, at 9:01 PM, Paul J. Davis wrote:

> Yep, the multi-key post doesn't require string keys.
>=20
> Also, when you want wild card behavior you need a view that has the =
non-wildcard selection criteria as a leading prefix. It's easiest to =
think about in terms of array slicing.
>=20
> For the OP I would suggest multiple views with the required array =
orders for the expected queries. =20
>=20
> On Feb 22, 2011, at 8:52 PM, Javier Julio <jjfutbol@gmail.com> wrote:
>=20
>> Andrey,
>>=20
>> Great question as I had been struggling with the same. In the docs =
its kind of buried there but you can post multiple keys to a view. I =
believe this is what you are looking for. Correct me if I'm wrong. So =
I'd create a view where the index has item, brand and category and then =
you can just include a key set for each grouping you want in the post =
body.
>>=20
>> If you look under the table with all the query params in this section =
of the View docs: =
http://wiki.apache.org/couchdb/HTTP_view_API#Querying_Options you'll see =
a that it mentions you can post multiple keys to a view.
>>=20
>> I'm still learning myself so I'm not sure if you can post complex =
keys (only simple strings are used). I would assume so since its not =
stated otherwise but I believe this is what will solve your problem.
>>=20
>> Ciao!
>> Javi
>>=20
>> On Feb 22, 2011, at 8:06 PM, Andrey Cherkashin wrote:
>>=20
>>> Hello,
>>>=20
>>> I have a problem, I can't understand how to write map function that =
solves my problem:
>>>=20
>>> I have a lot of "documents", each document has type (e.g. item,  =
user), category and brand. So i have map functions that gives me a list =
of every document that has type item (that's easy), but how i can get =
list of all documents that has brand =3D=3D xxx or category =3D=3D yyy =
or even brand=3D=3Dxxx&category=3Dzzz (xxx,yyy,zzz different every =
time).
>>=20