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