couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <rnew...@apache.org>
Subject Re: startkey and endkey
Date Tue, 30 Aug 2011 10:48:32 GMT
Try ?startkey=["Paint"]&endkey=["Paint",{}]

B.

On 30 August 2011 08:52, Ganzha Alexey <tretiy3@gmail.com> wrote:
> It looks like it will enough startkey=["Paint"]&endkey=["Paintz"]
> than for subcategory: ["Paint","Inside"]&endkey=["Paintz","Insidez"]
> or use '\u221e' instead of 'z'
>
> On Tue, Aug 30, 2011 at 10:04 AM, Andrey Cherkashin <andoriyu@gmail.com>wrote:
>
>> startkey=["Paint", " ", " ", 0]
>> endkey=["Paint", {}, {}, 0]
>>
>> 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:
>>
>> > Make Elements in startkey array the same type as keys emited.
>> > [string,string,string,int]
>> >
>> > On Tue, Aug 30, 2011 at 9:49 AM, Andrey Cherkashin <andoriyu@gmail.com
>> >wrote:
>> >
>> >> ["Paint", "Inside", "01-05.01-0002", 0]
>> >> ["Paint", "Inside", "01-05.01-0003", 0]
>> >> ["Paint", "Outside", "01-05.01-0004", 0]
>> >>
>> >>
>> >> On Aug 29, 2011, at 11:35 PM, Ganzha Alexey wrote:
>> >>
>> >>> More details required.
>> >>> Drop here some rows from your view.
>> >>>
>> >>> On Tue, Aug 30, 2011 at 9:29 AM, Andrey Cherkashin <andoriyu@gmail.com
>> >>> wrote:
>> >>>
>> >>>> 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:
>> >>>>
>> >>>>> 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.
>> >>>>>
>> >>>>> On Tue, Aug 30, 2011 at 8:33 AM, Andrey Cherkashin <
>> andoriyu@gmail.com
>> >>>>> wrote:
>> >>>>>
>> >>>>>> Hello everyone.
>> >>>>>>
>> >>>>>> I have a problem with using couch views that has "complex"
keys
>> like:
>> >>>>>> ["Category", "sub-cat", "sku", 100]
>> >>>>>>
>> >>>>>> For example, I trying to get all docs that is in "Paint"
category,
>> so
>> >> my
>> >>>>>> first guess was:
>> >>>>>> startkey=["Paint",0,0,0]&endkey=["Paint",{},{},{}]
>> >>>>>> but i got nothing. What am i doing wrong?
>> >>>>
>> >>>>
>> >>
>> >>
>>
>>
>

Mime
View raw message