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 siriele2x3@gmail.com
 designates 209.85.212.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAHKsR68UeF4Z7ZwfZVG5CAwZGX+9VDzvvUtb8d7qXaQf9gff4g@mail.gmail.com>
References: 
 <CAHKsR6-VAUROQ=Fi8LU4kFW8QzpYkSReCZ0QDOBEzsvh78asmw@mail.gmail.com>
	<CAPNuaCgoDx4dPtqKHYHmBjOZCNNkvQxzzCFz8TcATritmCk3gA@mail.gmail.com>
	<CABvT1DGK5+xA8bFg8=0jqKNNSN=Dp=dW4hN569TEBCNdLs1yfw@mail.gmail.com>
	<CAHKsR68=vwcKuDjUx6m6ET+SHwLGH7x_fcdCeooSQV+fOV8iiw@mail.gmail.com>
	<CAPNuaCgHnNhLnJTTfaTeaahh=ABB_rmLpBHctAhG=KJX+qVvZg@mail.gmail.com>
	<CAHKsR68oS3hsCsRN==Fx2J-TzfNh7ero+=gZOnzqFRE-nANqhw@mail.gmail.com>
	<CAPNuaCgt63wVz9M3qoqhLy1x3RVZdtpJJz=7mbi5SexcBthTHA@mail.gmail.com>
	<CAHKsR6-cEZ-SWDPywzJ8ukkmduQfFgi6P9Pk=V413uvqUHr0jA@mail.gmail.com>
	<CAPNuaCiCfC3Ym_BTEXDCwQ7uW_CvBUA+xo0FmH05+QW5bAQgbw@mail.gmail.com>
	<CAHKsR68UeF4Z7ZwfZVG5CAwZGX+9VDzvvUtb8d7qXaQf9gff4g@mail.gmail.com>
Date: Mon, 1 Jul 2013 14:02:30 -0700
Message-ID: 
 <CAPNuaCjQJ+=UEak-boUn0jW1knO1kNNynN3R9vce-1YED=yUgA@mail.gmail.com>
Subject: Re: How to sort this view
From: Stanley Iriele <siriele2x3@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=e89a8f5030acf1d0c004e0798b01

--e89a8f5030acf1d0c004e0798b01
Content-Type: text/plain; charset=ISO-8859-1

But if you reverse that emit and reverse that key you should be fine
On Jul 1, 2013 1:53 PM, "bryan rasmussen" <rasmussen.bryan@gmail.com> wrote:

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

--e89a8f5030acf1d0c004e0798b01--