Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <AANLkTinP_EUaBdweubj4ER=GGH=+BuofDw2Mj2Hbj7H3@mail.gmail.com>
References: <AANLkTimKUE9aaNiSKYGjKEgzoxGYX7uOuUT0FS2Exfe0@mail.gmail.com>
 <AANLkTi=Sj0ufYZNqXdJUophu-OAd62dv8ivvNnR1-C_J@mail.gmail.com>
 <E398DF7E-F05E-4D8F-ACA4-493D95A2C076@gmail.com>
 <AANLkTimQ6P0_7mO+7J1apvYT1zTC-OA6mSyJo2cLBte2@mail.gmail.com>
 <C0A89B84-4DDD-4A98-A6E9-051531A1DF08@gmail.com>
 <AANLkTinD5vmC=TR6ckC_C4JgPELPTWXLWURCy0MWtKMF@mail.gmail.com>
 <AANLkTinP_EUaBdweubj4ER=GGH=+BuofDw2Mj2Hbj7H3@mail.gmail.com>
From: Mark Hahn <mark@elleh.com>
Date: Thu, 10 Feb 2011 08:08:06 -0800
Message-ID: <AANLkTimVLXxVzv=h6WH=+OvGyw9Spt_mgcSkgDGc_1yQ@mail.gmail.com>
Subject: Re: wrong view results?
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I don't think so.  I didn't generate the URL, jquery.couch.js did.  It
works fine.

On Thu, Feb 10, 2011 at 7:17 AM, Anup Bishnoi <pixelsallover@gmail.com> wro=
te:
> 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. =A0I had keystart (duh). =A0Thanks
>> 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 a=
ll
>> 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. =A0Of c=
ourse
>> >>>>> if I am doing something wrong it would be no surprise.
>> >>>>>
>> >>>>> I have a view called itemByEmailNum. =A0Here is the definition of =
the
>> view ...
>> >>>>>
>> >>>>> function(doc) {
>> >>>>> =A0if(doc.type =3D=3D 'item')
>> >>>>> =A0 =A0emit([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=3Dsusan%40elleh.com=
, 0
>> &
>> >>>>> keyend=3Dsusan%40elleh.com, 1000000000 & include_docs=3Dtrue &
>> >>>>> descending=3Dtrue
>> >>>>>
>> >>>>> This should not have gotten any results since the only docs have t=
he
>> >>>>> first key of "root" and both the keystart and keyend in this reque=
st
>> >>>>> have a first key of susan%40elleh.com. =A0Here are the results it
>> >>>>> returned. =A0I'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. =A0I'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.
>> >
>> >
>>
>