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
 74.125.83.53 as permitted sender)
Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Apple Message framework v1249)
Subject: Re: startkey and endkey
From: Andrey Cherkashin <andoriyu@gmail.com>
In-Reply-To: <33F4703E-06A7-46E4-97C1-350FCC12F9E4@gmail.com>
Date: Tue, 6 Sep 2011 15:44:16 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <7DD82927-E595-4ED5-8420-9C09B0599F9B@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>
 <825CEB7F-CBCF-4E63-8698-42B4D1CE3530@gmail.com>
 <33F4703E-06A7-46E4-97C1-350FCC12F9E4@gmail.com>
To: user@couchdb.apache.org

It works, but only for keys in english, for example it will return =
nothing if i query "=D0=9A=D1=80=D0=B0=D1=81=D0=BA=D0=B8".

curl https://couch.dev/project_ngein-sac_dev/_design//Item/_view/filter =
:

=
{"id":"Item--10-01.02-1211--624525","key":["\u0414\u0440\u0443\u0433\u043e=
\u0435","\u0414\u0440\u0443\u0433\u043e\u0435","10-01.02-1211",0],"value":=
null},
=
{"id":"Item--10-01.01-1111--919678","key":["\u041a\u0440\u0430\u0441\u043a=
\u0438","\u0432\u043d\u0435\u0448\u043d\u0438\u0435 =
\u0440\u0430\u0431\u043e\u0442\u044b","10-01.01-1111",0],"value":null},


On Sep 1, 2011, at 3:11 AM, F=C3=A1bio Batalha wrote:

>=20
>>> Try ?startkey=3D["Paint"]&endkey=3D["Paintz",{}]
>=20
> Sent from my iPhone
>=20
> On 31/08/2011, at 22:53, Andrey Cherkashin <andoriyu@gmail.com> wrote:
>=20
>> Any ideas?
>> On Aug 30, 2011, at 3:48 AM, Robert Newson wrote:
>>=20
>>> 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
>>=20