couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Hahn <m...@elleh.com>
Subject Re: wrong view results?
Date Thu, 10 Feb 2011 01:23:37 GMT
I didn't have startkey or start_key.  I had keystart (duh).  Thanks
for pointing me in the right direction.

On Wed, Feb 9, 2011 at 4:46 PM, Javier Julio <jjfutbol@gmail.com> wrote:
> It looked odd to me at first too and I just happened to have that page open. Glad I checked.
Yeah makes sense its used a lot. Nice that either one will be supported!
>
> Are you getting the correct results now Mark? Let us know.
>
> On Feb 9, 2011, at 7:42 PM, Paul Davis wrote:
>
>> On Wed, Feb 9, 2011 at 7:37 PM, Javier Julio <jjfutbol@gmail.com> wrote:
>>> No it should be "startkey" and "endkey" (no underscores, has to be all lowercase
otherwise not recognized). http://wiki.apache.org/couchdb/HTTP_view_API
>>>
>>> On Feb 9, 2011, at 7:31 PM, Paul Davis wrote:
>>>
>>>> On Wed, Feb 9, 2011 at 5:52 PM, Mark Hahn <mark@elleh.com> wrote:
>>>>> I'm getting what seems to me to be the wrong view results.  Of course
>>>>> if I am doing something wrong it would be no surprise.
>>>>>
>>>>> I have a view called itemByEmailNum.  Here is the definition of the
view ...
>>>>>
>>>>> function(doc) {
>>>>>  if(doc.type == 'item')
>>>>>    emit([doc.email, doc.itemNumber], null);
>>>>>
>>>>> Here is what I get from that view with no keys specified.
>>>>>
>>>>> {"total_rows":2,"offset":0,"rows":[
>>>>> {"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null},
>>>>> {"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null}
>>>>> ]}
>>>>>
>>>>> Here is the url of the view that seems to give the wrong results.
>>>>> I've added spaces here for clarity.
>>>>>
>>>>> /bb/_design/bb/_view/itemByEmailNum ? keystart=susan%40elleh.com, 0 &
>>>>> keyend=susan%40elleh.com, 1000000000 & include_docs=true &
>>>>> descending=true
>>>>>
>>>>> This should not have gotten any results since the only docs have the
>>>>> first key of "root" and both the keystart and keyend in this request
>>>>> have a first key of susan%40elleh.com.  Here are the results it
>>>>> returned.  I've snipped the doc properties for clarity.
>>>>>
>>>>> {"total_rows":2,"offset":0,"rows":[
>>>>> {"id":"86d5d83c65c3d901e29c7567be001e68","key":["root",13],"value":null,"doc":{
>>>>> ... }},
>>>>> {"id":"86d5d83c65c3d901e29c7567be001233","key":["root",12],"value":null,"doc":{
>>>>> ... }}
>>>>> ]}
>>>>>
>>>>> Any help would be appreciated.  I'm using CouchDB 1.0.1.
>>>>>
>>>>
>>>> keystart and keyend should be start_key and end_key.
>>>
>>>
>>
>> Ah right. Older versions are still on the no underscore version. 1.1.0
>> and beyond will recognize both because people tend to add the
>> underscore.
>
>

Mime
View raw message