incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Cherkashin <andor...@gmail.com>
Subject Re: startkey and endkey
Date Tue, 30 Aug 2011 07:04:42 GMT
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