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.