Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of andoriyu@gmail.com designates
 209.85.213.180 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1249)
Subject: Re: startkey and endkey
From: Andrey Cherkashin <andoriyu@gmail.com>
In-Reply-To: 
 <CABvT1DG-FUA1H=DL_bnLQ48jgT1qC8mnZ=x9bpOrfmwgmpy+pg@mail.gmail.com>
Date: Wed, 31 Aug 2011 18:53:26 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <825CEB7F-CBCF-4E63-8698-42B4D1CE3530@gmail.com>
References: <F716D48E-C396-4B10-B342-33F96450DCE9@gmail.com>
 <CA+ckZiCfSNkQwFnXSfz7CzyDZ01_Q+xawYLVhbJ=nQQcj_Yv5w@mail.gmail.com>
 <E06172F9-90CF-4E09-AE1D-CA59ACC47E55@gmail.com>
 <CA+ckZiBDHMgmqnN2cM51gdBUe1xtzXCNO64WSiGGs4Vs76ed_g@mail.gmail.com>
 <28EAF0D9-BC45-463B-AE57-B8C95E045C63@gmail.com>
 <CA+ckZiB4B3+CGgZU_oi4VddaeK0GiLe+hcJMxQ1-03v0Ku1Mww@mail.gmail.com>
 <5C1A6DAC-17E3-485D-8571-5AFE11A2A207@gmail.com>
 <CA+ckZiA3q0Vstcm6MoUUsiW2TW3jToeihnOif69gb=mPogUz9g@mail.gmail.com>
 <CABvT1DG-FUA1H=DL_bnLQ48jgT1qC8mnZ=x9bpOrfmwgmpy+pg@mail.gmail.com>
To: user@couchdb.apache.org

Any ideas?
On Aug 30, 2011, at 3:48 AM, Robert Newson wrote:

> Try ?startkey=3D["Paint"]&endkey=3D["Paint",{}]
>=20
> B.
>=20
> On 30 August 2011 08:52, Ganzha Alexey <tretiy3@gmail.com> wrote:
>> It looks like it will enough startkey=3D["Paint"]&endkey=3D["Paintz"]
>> than for subcategory: ["Paint","Inside"]&endkey=3D["Paintz","Insidez"]
>> or use '\u221e' instead of 'z'
>>=20
>> On Tue, Aug 30, 2011 at 10:04 AM, Andrey Cherkashin =
<andoriyu@gmail.com>wrote:
>>=20
>>> startkey=3D["Paint", " ", " ", 0]
>>> endkey=3D["Paint", {}, {}, 0]
>>>=20
>>> nothing. Btw, i'm trying to get all docs in one specific category, =
then in
>>> category and sub-category.
>>> On Aug 29, 2011, at 11:58 PM, Ganzha Alexey wrote:
>>>=20
>>>> Make Elements in startkey array the same type as keys emited.
>>>> [string,string,string,int]
>>>>=20
>>>> On Tue, Aug 30, 2011 at 9:49 AM, Andrey Cherkashin =
<andoriyu@gmail.com
>>>> wrote:
>>>>=20
>>>>> ["Paint", "Inside", "01-05.01-0002", 0]
>>>>> ["Paint", "Inside", "01-05.01-0003", 0]
>>>>> ["Paint", "Outside", "01-05.01-0004", 0]
>>>>>=20
>>>>>=20
>>>>> On Aug 29, 2011, at 11:35 PM, Ganzha Alexey wrote:
>>>>>=20
>>>>>> More details required.
>>>>>> Drop here some rows from your view.
>>>>>>=20
>>>>>> On Tue, Aug 30, 2011 at 9:29 AM, Andrey Cherkashin =
<andoriyu@gmail.com
>>>>>> wrote:
>>>>>>=20
>>>>>>> When I do exact match in start key and end key, i got 0 results.
>>>>>>> On Aug 29, 2011, at 11:26 PM, Ganzha Alexey wrote:
>>>>>>>=20
>>>>>>>> Hello.
>>>>>>>> Your start key must match exactly some key in database.
>>>>>>>> It is like an anchor. After db hits your start key, it begn =
emit for
>>>>> you
>>>>>>> all
>>>>>>>> rows with the key which is less than startkey according to view
>>>>>>> collation.
>>>>>>>>=20
>>>>>>>> On Tue, Aug 30, 2011 at 8:33 AM, Andrey Cherkashin <
>>> andoriyu@gmail.com
>>>>>>>> wrote:
>>>>>>>>=20
>>>>>>>>> Hello everyone.
>>>>>>>>>=20
>>>>>>>>> I have a problem with using couch views that has "complex" =
keys
>>> like:
>>>>>>>>> ["Category", "sub-cat", "sku", 100]
>>>>>>>>>=20
>>>>>>>>> For example, I trying to get all docs that is in "Paint" =
category,
>>> so
>>>>> my
>>>>>>>>> first guess was:
>>>>>>>>> startkey=3D["Paint",0,0,0]&endkey=3D["Paint",{},{},{}]
>>>>>>>>> but i got nothing. What am i doing wrong?
>>>>>>>=20
>>>>>>>=20
>>>>>=20
>>>>>=20
>>>=20
>>>=20
>>=20