couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <rnew...@apache.org>
Subject Re: How to sort this view
Date Mon, 01 Jul 2013 20:24:14 GMT
http://wiki.apache.org/couchdb/HTTP_view_API#Querying_Options

The view is sorted by the full key, you can't ask for it to return
ascending on the first item and descending on the second, if that's
the question?

I think you just need ?descending=true when you query in this case, though.

B.



On 1 July 2013 21:18, bryan rasmussen <rasmussen.bryan@gmail.com> wrote:
> I agree it is ascending in value, but how to make it descend.
>
> thanks,
> Bryan
>
> On Mon, Jul 1, 2013 at 10:14 PM, Stanley Iriele <siriele2x3@gmail.com> wrote:
>> Sorry I read that wrong... I thought all keys were the same "should
>> probably be wearing my glasses" it looks like its sorting normally... The
>> second column is ascending in value as you'd expect
>> On Jul 1, 2013 1: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