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 fynwine@gmail.com designates
 209.85.220.226 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:reply-to:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=Afdfb7Jlksjlv+/5bVueHHcxq0/AEYnxqOZlA/Pj8MJq2iFyVsEeTbY9DkiCyKLlwr
         QepcfJutinrbuwOv4RgZKU/7+c0Cx7/owmI/3JHj2HaXhTceZq8FVo+3OAHtjXq/fNSR
         wkKlvGe8ylT7bVkUIGdFD5it8iaaOvL6Ei8hw=
MIME-Version: 1.0
Sender: fynwine@gmail.com
Reply-To: aj@ajbrown.org
In-Reply-To: <DAF7A914-EB41-4370-B380-0824879308F7@culture.gouv.fr>
References: <f584a1751003231451p6e01198fu35541455022f6210@mail.gmail.com>
	 <DAF7A914-EB41-4370-B380-0824879308F7@culture.gouv.fr>
Date: Wed, 24 Mar 2010 10:42:11 -0400
Message-ID: <f584a1751003240742o29e64938mb665480df43d8ee9@mail.gmail.com>
Subject: Re: Help With View Query
From: "A.J. Brown" <aj@ajbrown.org>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks guys, that was it.  Glad to know that I at least knew what I
was doing as far as they keys themselves were concerned.

2010/3/24 COING G=E9rard <gerard.coing@culture.gouv.fr>:
>
> Le 23 mars 2010 =E0 22:51, A.J. Brown a =E9crit :
>
>> Hi All,
>>
>> I'm having some trouble querying a view. =A0Can you help me out? =A0I'm
>> trying to query a view of comments for a specific topic. =A0My view has
>> the topic document id and a ISO date string as the key.
>>
>> I've tried many combinations of the following, but no matter what I
>> always get the entire list of comments back. =A0There are 3 comments in
>> the database that should match (have the correct topic_id) and 6 total
>> rows.
>>
>> startKey=3D["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=3D["2e7768c5=
09e896e658ecb75f3c1cf84c",{}]
>> startKey=3D["2e7768c509e896e658ecb75f3c1cf84c"]&endKey=3D["2e7768c509e89=
6e658ecb75f3c1cf84c",{}]
>> startKey=3D["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=3D["2e7768c5=
09e896e658ecb75f3c1cf84c","\u9999"]
>> startKey=3D["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=3D["2e7768c5=
09e896e658ecb75f3c1cf84c",null,
>> null]
>
> I think your problem is here : "startkey" and "endkey" (all in lower case=
)
>
>>
>> Here's the map function for that view:
>>
>> function(doc) {if( doc.type =3D=3D 'comment' ) { emit( [doc.topic_id,
>> doc.created], doc );}}
>>
>> And here's an example comment document:
>>
>> {
>> =A0 "_id": "1b324c9430cd734bc08ae773c659170c",
>> =A0 "_rev": "1-8526badbb1259f10cd4b938a2e7c3918",
>> =A0 "type": "comment",
>> =A0 "author": "ajbrown",
>> =A0 "topic_id": "2e7768c509e896e658ecb75f3c1cf84c",
>> =A0 "parent_comment_id": "",
>> =A0 "message": "tsetst etettstts",
>> =A0 "created": "2010-03-23T17:32:19-04:00"
>> }
>>
>> In Futon, my keys look right. =A0Example:
>>
>> ["2e7768c509e896e658ecb75f3c1cf84c", "2010-03-23T17:32:19-04:00"]
>>
>> --
>> A.J. Brown
>> Software Engineer, ZCE
>> blog : http://ajbrown.org
>> talk =A0: (937) 540-0099
>> chat : IntypicaAJ
>
>


--=20
A.J. Brown
Software Engineer, ZCE
blog : http://ajbrown.org
talk  : (937) 540-0099
chat : IntypicaAJ