But at the same time it isn't working in Couchrest::model :
>> Item.filter.startkey('["io"]').endkey('["ioz",{}]').to_a
[]
On Sep 1, 2011, at 3:11 AM, Fábio Batalha wrote:
>
>>> Try ?startkey=["Paint"]&endkey=["Paintz",{}]
>
> Sent from my iPhone
>
> On 31/08/2011, at 22:53, Andrey Cherkashin <[email protected]> wrote:
>
>> 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 <[email protected]> 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
>>>> <[email protected]>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 <[email protected]
>>>>>> 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 <[email protected]
>>>>>>>> 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 <
>>>>> [email protected]
>>>>>>>>>> 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?
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>
>>
