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 paul.joseph.davis@gmail.com
 designates 209.85.132.240 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=HMEAGyPWx8TasPysfL4xD9JuouESxmQQ0X9Z5xdJslGm9rTanrJ6k0pa2Ai3rRLfHE
         AVce+9HyEyBEIgZ0aMIrDSa0vJIjlYYYZ6yzKGwDl5nCmNMcd6FowQLfkI+/3gUya+iR
         wEQQKTFiUVHMQayY2oxvXiVL2pNre8I3bYPLk=
MIME-Version: 1.0
In-Reply-To: <9FAC311C-E0DD-430A-AD3D-406E4716E7D8@gmail.com>
References: <9FAC311C-E0DD-430A-AD3D-406E4716E7D8@gmail.com>
Date: Sun, 19 Jul 2009 22:16:00 -0400
Message-ID: <e2111bbb0907191916u601fb5eaud8fae9423bd9dcb8@mail.gmail.com>
Subject: Re: multiple key word count query problem
From: Paul Davis <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sun, Jul 19, 2009 at 9:14 PM, Tommy Chheng<tommy.chheng@gmail.com> wrote=
:
> I have a simple word count view defined as:
> --------
> function(doc) {
> =A0if(doc['couchrest-type'] =3D=3D 'NsfGrant'){
> =A0 =A0var words =3D doc['abstract'].split(/\W+/);
> =A0 =A0words.forEach(function(word){
> =A0 =A0 =A0if (word.length > 1) emit([word, doc['_id']],1);
> =A0 =A0});
> =A0}
> }
>
> function(keys, values, rereduce) {
> =A0return sum(values);
> }
> --------
> where the key's first parameter is the word and the 2nd parameter is the
> document_id.
>
> so i can do a query like this to get all the documents with the word "the=
"
> correctly.
> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count=
?startkey=3D["the"]&endkey=3D["the",{}]&group_level=3D2
>
> I'm having trouble doing queries on the 2nd parameter, how can i find all
> the words in a particular document?
> I tried
> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count=
?key=3D[null,"0808605"]&group_level=3D2
> which gives nothing(thinking that null would match all words)
> and
> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count=
?startkey=3D[null,"0808605"]&endkey=3D[{},"0808605"]&group_level=3D2
> which gives all results. Why is this?
>
> Thanks,
> Tommy
>

Querying a view is asking for a slice of a sorted list. Start and end
keys delimit the range of rows returned. The solution to your problem
is to create a second view so you can query by docid.

Paul Davis