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 awolff@gmail.com designates
 209.85.221.175 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=k5YgXtA8q39IB71EcaVWLghXRU+JdXZe1Zf0D9tF50K+N5oQ9BqTyOoEYMcEnqj+h/
         MCQVsdgCkkeTkCcXexy84rWOFywwgRgjK7+m3AeFXEghR714lW7/1HE3UFYXPMA9fmvD
         2ATVk/BR4tggixJJaJq/8YAivbgsx772kb7Pw=
MIME-Version: 1.0
In-Reply-To: <4BC489AF.4030504@vpro.nl>
References: <i2rf96ce4411004122103gf62e6f8bm2b35c478022dea0c@mail.gmail.com>
	 <4BC489AF.4030504@vpro.nl>
Date: Tue, 13 Apr 2010 10:14:53 -0700
Message-ID: <j2ze8d26ac41004131014y598d2705n6ad6bb7c0d8d3c73@mail.gmail.com>
Subject: Re: MultiKey sorting in views
From: Adam Wolff <awolff@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0016362842fa6e6c670484216640

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

I understood the issue to be that if you query for multiple authors, the
results are sorted by author, then by date. You'd need to merge the results
for each author to get a chronological list of documents by date. I don't
think there's a simple fix for this, right?

A

On Tue, Apr 13, 2010 at 8:11 AM, Nils Breunese <N.Breunese@vpro.nl> wrote:

> Pavan Kumar wrote:
>
>   I have documents with author and submitted time ( utc value of date )
>> fields . Now i need to sort descending ( i.e latest first ) on time and
>> filter by author in a view.
>>
>> I tried a few things like given below but they don't work. My "view"
>> knowledge needs lot of catching up.. Any pointers would help..
>>
>> 1) Filters by author but doesn't sort by time
>>
>> startkey: [ author , 0 ]
>> endkey : [ author, now ]
>> descending : true
>>
>> Map:
>> emit([doc.author,doc.submit_at],doc )
>>
>
> What is the format of your submit_at field? If you use a format that
> alfabetically sorts like it would do if you sorted chronologically, then
> this would work, right? I use something like that myself using
> timestamps in RFC 3339 format ("Date and Time on the Internet:
> Timestamps") [0] which look like this:
>
>       2010-04-13T17:00:00+01:00
>
>       (year-month-dayThours:minutes:seconds and optional offset)
>
> The view keys will automatically be sorted alfabetically, but for RFC
> 3339 timestamps this will also be chronologically. I guess things like
> UNIX timestamps stored as a JSON number would also work, but they don't
> score as high on the human readability scale.
>
> Nils Breunese.
>
> [0] http://www.ietf.org/rfc/rfc3339.txt
>
> De informatie vervat in deze  e-mail en meegezonden bijlagen is uitsluitend
> bedoeld voor gebruik door de geadresseerde en kan vertrouwelijke informatie
> bevatten. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking
> van deze informatie aan derden is voorbehouden aan geadresseerde. De VPRO
> staat niet in voor de juiste en volledige overbrenging van de inhoud van een
> verzonden e-mail, noch voor tijdige ontvangst daarvan.
>

--0016362842fa6e6c670484216640--