couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bryan rasmussen <rasmussen.br...@gmail.com>
Subject Re: How to sort this view
Date Mon, 01 Jul 2013 20:53:30 GMT
damn, you're right. I had deleted the other testing key earlier.


On Mon, Jul 1, 2013 at 10:38 PM, Stanley Iriele <siriele2x3@gmail.com> wrote:
> [{},"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
View raw message