Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of rasmussen.bryan@gmail.com
 designates 74.125.82.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABvT1DGK5+xA8bFg8=0jqKNNSN=Dp=dW4hN569TEBCNdLs1yfw@mail.gmail.com>
References: 
 <CAHKsR6-VAUROQ=Fi8LU4kFW8QzpYkSReCZ0QDOBEzsvh78asmw@mail.gmail.com>
	<CAPNuaCgoDx4dPtqKHYHmBjOZCNNkvQxzzCFz8TcATritmCk3gA@mail.gmail.com>
	<CABvT1DGK5+xA8bFg8=0jqKNNSN=Dp=dW4hN569TEBCNdLs1yfw@mail.gmail.com>
Date: Mon, 1 Jul 2013 22:16:25 +0200
Message-ID: 
 <CAHKsR68=vwcKuDjUx6m6ET+SHwLGH7x_fcdCeooSQV+fOV8iiw@mail.gmail.com>
Subject: Re: How to sort this view
From: bryan rasmussen <rasmussen.bryan@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

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