couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Iriele <siriele...@gmail.com>
Subject Re: How to sort this view
Date Mon, 01 Jul 2013 20:38:59 GMT
[{},"oeerpa189"] is equivalent to [{}] as far as I've seen...it may be that
you don't have any other key so its not obvious
On Jul 1, 2013 1:28 PM, "bryan rasmussen" <rasmussen.bryan@gmail.com> wrote:

> ah you're right, I needed to do startkey=[{},"ueoorp189"] and
> descending=true to get it to sort right.
>
> Thanks,
> Bryan
>
>
> On Mon, Jul 1, 2013 at 10:22 PM, Stanley Iriele <siriele2x3@gmail.com>
> wrote:
> > Put reverse your start key end key
> > On Jul 1, 2013 1:22 PM, "bryan rasmussen" <rasmussen.bryan@gmail.com>
> wrote:
> >
> >> right I need to only get the first key, but sort by the second.
> >>
> >> On Mon, Jul 1, 2013 at 10:19 PM, Stanley Iriele <siriele2x3@gmail.com>
> >> wrote:
> >> > Do you care about other keys being mixed in?....I guess are you
> trying yo
> >> > group by that first key that you have?
> >> > Well if I put the second item first, like:
> >> >
> >> > [13023123123, "ueoorp189"]
> >> >
> >> > How do I query that, given that I don't know what my first value is
> >> > going to be, but I do know that my second value is ueoorp189
> >> >
> >> > Thanks,
> >> > Bryan
> >> >
> >> > On Mon, Jul 1, 2013 at 10:11 PM, Robert Newson <rnewson@apache.org>
> >> wrote:
> >> >> Views are sorted by their key (the whole key and nothing but the
> key).
> >> >> So make a view with your second item first to get the order you
> >> >> require.
> >> >>
> >> >> B.
> >> >>
> >> >>
> >> >> On 1 July 2013 21:04, Stanley Iriele <siriele2x3@gmail.com> wrote:
> >> >>> What are the 1st and second values... Couch dB is sorting correctly
> >> > you're
> >> >>> just jot giving it the data it needs to sort on... So what values
> are
> >> you
> >> >>> trying to sort by?
> >> >>> On Jul 1, 2013 12:48 PM, "bryan rasmussen" <
> rasmussen.bryan@gmail.com>
> >> >>> wrote:
> >> >>>
> >> >>>> Hi,
> >> >>>>
> >> >>>> I have a view that outputs like the following:
> >> >>>>
> >> >>>> ["ueoorp189", 13023123123]
> >> >>>>
> >> >>>> ["ueoorp189", 13023123125]
> >> >>>>
> >> >>>> ["ueoorp189", 13023153123]
> >> >>>>
> >> >>>> ["ueoorp189", 13073123123]
> >> >>>> I want a query that sorts it descending with the highest value
in
> the
> >> >>>> second key
> >> >>>>
> >> >>>> From what I've read this should be possible but I am not finding
my
> >> >>>> way to making it work.
> >> >>>>
> >> >>>> Do I have to do a map reduce function to do it?
> >> >>>>
> >> >>>> Thanks,
> >> >>>> Bryan Rasmussen
> >> >>>>
> >>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message