couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anup Bishnoi <pixelsallo...@gmail.com>
Subject Re: wrong view results?
Date Thu, 10 Feb 2011 15:17:38 GMT
also i think you'll have to put square brackets around the start and end key
values in the url

On Thu, Feb 10, 2011 at 6:53 AM, Mark Hahn <mark@elleh.com> wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message