couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A.J. Brown" ...@ajbrown.org>
Subject Re: Help With View Query
Date Wed, 24 Mar 2010 14:42:11 GMT
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érard <gerard.coing@culture.gouv.fr>:
>
> Le 23 mars 2010 à 22:51, A.J. Brown a écrit :
>
>> Hi All,
>>
>> I'm having some trouble querying a view.  Can you help me out?  I'm
>> trying to query a view of comments for a specific topic.  My 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.  There are 3 comments in
>> the database that should match (have the correct topic_id) and 6 total
>> rows.
>>
>> startKey=["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=["2e7768c509e896e658ecb75f3c1cf84c",{}]
>> startKey=["2e7768c509e896e658ecb75f3c1cf84c"]&endKey=["2e7768c509e896e658ecb75f3c1cf84c",{}]
>> startKey=["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=["2e7768c509e896e658ecb75f3c1cf84c","\u9999"]
>> startKey=["2e7768c509e896e658ecb75f3c1cf84c",null]&endKey=["2e7768c509e896e658ecb75f3c1cf84c",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 == 'comment' ) { emit( [doc.topic_id,
>> doc.created], doc );}}
>>
>> And here's an example comment document:
>>
>> {
>>   "_id": "1b324c9430cd734bc08ae773c659170c",
>>   "_rev": "1-8526badbb1259f10cd4b938a2e7c3918",
>>   "type": "comment",
>>   "author": "ajbrown",
>>   "topic_id": "2e7768c509e896e658ecb75f3c1cf84c",
>>   "parent_comment_id": "",
>>   "message": "tsetst etettstts",
>>   "created": "2010-03-23T17:32:19-04:00"
>> }
>>
>> In Futon, my keys look right.  Example:
>>
>> ["2e7768c509e896e658ecb75f3c1cf84c", "2010-03-23T17:32:19-04:00"]
>>
>> --
>> A.J. Brown
>> Software Engineer, ZCE
>> blog : http://ajbrown.org
>> talk  : (937) 540-0099
>> chat : IntypicaAJ
>
>



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

Mime
View raw message