incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fábio Batalha <fabiobata...@gmail.com>
Subject Re: startkey and endkey
Date Thu, 01 Sep 2011 10:11:06 GMT

>> 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