incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ganzha Alexey <tret...@gmail.com>
Subject Re: startkey and endkey
Date Tue, 30 Aug 2011 07:52:06 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message