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