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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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. > >
