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 Thu, 01 Sep 2011 01:53:26 GMT
Any ideas?
On Aug 30, 2011, at 3:48 AM, Robert Newson wrote:

> 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