Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of frederick.bowen@gmail.com
 designates 209.85.214.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=L35ePZBZxWe+TGBVbGhX3M3jwl0tiSK/AevntfYr78ja1Gqauz98/75INVFcTY3RY6
         a20JoRfB4TTQWlA527XK1Vz3EfHjZ3LbswFEvZAKF/QOf23YZx42VSdy1/tXRzLq4Iy4
         vodwj4z8Q5HbZjhAJbsUPv8ECKyaPLJ7Rcvuo=
MIME-Version: 1.0
In-Reply-To: <AANLkTi=MztcAV1jHcXP7Mp-6B2mg1i1py_DJ9w9OoJH2@mail.gmail.com>
References: <AANLkTik_4ePkMfEpYEOJVMHLwA_smzk2Zdi+-KJC-XfU@mail.gmail.com>
	<AANLkTinRtA0m7RkX4Mgi5NN-_hb-PgGI6XdMjhdX8OqC@mail.gmail.com>
	<AANLkTi=MztcAV1jHcXP7Mp-6B2mg1i1py_DJ9w9OoJH2@mail.gmail.com>
From: Freddy Bowen <frederick.bowen@gmail.com>
Date: Wed, 21 Jul 2010 17:20:27 -0400
Message-ID: <AANLkTileI0yQi0cC44KgYg14AyVXAljRYQDQYFV09x1E@mail.gmail.com>
Subject: Re: a newbie question about querying an exact array field
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00032555a3da1e3469048bec609f

--00032555a3da1e3469048bec609f
Content-Type: text/plain; charset=UTF-8

I don't quite understand your predicament.

But take the doc:
{"_id": "example1","my_array": [1,2,3,4,5]}

To index your lists just make a view like:
function(doc){ emit(doc.my_array, null); }

Find your doc in a view:
http://yourcouch/db/_design/dd/_view/ex?startkey=[1,2,3,4,5]&endkey=[1,2,3,4,5]

Which returns:
{"total_rows":1,"offset":0,"rows":[
{"id":"example1","key":[1,2,3,4,5],"value":null}
]}

Beware that startkey=[1,2,3,4,5]&endkey=[1,2,3,4,5] matches everything that
sorts in between.

FB


On Wed, Jul 21, 2010 at 4:33 PM, Richard Llewellyn <llewelr@gmail.com>wrote:

> Thanks all for quick comments and heads up with javascript!  I was under
> the
> dreamy impression that the array query value would be json encoded
> automagically.
>
> I am storing values with simple keys but json lists and dicts and would
> like
> to index these values by exposing them in a view, not as their individual
> elements (I find the many 'tag' examples) but in their entirety.
>
> >>You'll either have to json encode or hash the array and then compare
> the hashes.
>
> Ok that makes sense, but how do I query with a json encoded value?  I can
> encode an array to json, and the arrays should be json already in the db,
> but how would I write the query?
>
> How do I do what I mean below?  Naively replacing my_array with a json
> string eg "[1, 2, 3, 4, 5]" doesn't work.
>
> eg doc.array = [1,2,3,4,5]
>
> function(doc){
>  if (doc.my_array == my_array in CLIENT ENCODED JSON)
> { emit(doc.my_array, doc);
> }}
>
> Thanks,
> Rich
>

--00032555a3da1e3469048bec609f--