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, 06 Sep 2011 22:45:59 GMT
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 <andoriyu@gmail.com> 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 <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