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 simon@cloudant.com designates
 209.85.212.181 as permitted sender)
Date: Fri, 4 Jan 2013 10:38:20 +0000
From: Simon Metson <simon@cloudant.com>
To: user@couchdb.apache.org
Message-ID: <65E0D86D4D7947D5A7E19D42FBB7547C@cloudant.com>
In-Reply-To: 
 <CAEjRLuS-1oOMWSULxj9TBAtSQwSaGjCkOGzrs6FB0+LZsMvyRg@mail.gmail.com>
References: 
 <CAEjRLuS-1oOMWSULxj9TBAtSQwSaGjCkOGzrs6FB0+LZsMvyRg@mail.gmail.com>
Subject: Re: view ordered by DateTime
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hey, =20
You need to either covert the date into a number (epoch seconds or simila=
r) or make the date stamp into a date object and emit the pieces, e.g.:

function(doc) =7B
  date =3D new Date(Date.parse(doc.date));
  emit(=5Bdate.getUTC=46ullYear(), date.getUTCMonth(), date.getUTCDay(), =
date.getUTCHours(), date.getUTCMinutes()=5D, doc.text);
=7D


The advantage of doing the date key as a list is you can have a reduce (l=
ike =5Fcount) and see number of documents at the different group levels (=
year, month, day=E2=80=A6)
Cheers
Simon


On =46riday, 4 January 2013 at 10:30, ishi soichi wrote:

> couchdb latest
> python 2.7
> ruby 1.9.3
> =20
> I have a database obtained from Twitter.
> Each tweet contains the information about when it's created, namely,
> created=5Fat.
> =20
> The problem is if I try to view them with the function
> =20
> function(doc) =7B
> if (doc=5B'created=5Fat'=5D =21=3D null) =7B
> emit(doc=5B'created=5Fat'=5D, doc=5B'text'=5D);
> =7D
> =7D
> =20
> the tweets are ordered ALPHABETICALLY, not by datetime.
> =20
> This is because the data is stored in couchdb in the form of String rat=
her
> than DateTime object.
> =20
> How can I order the outputs by DateTime=3F
> =20
> I can program in JavaScript, Ruby(couchrest), and Python, I appreciate
> concrete example using any of these languages.
> =20
> soichi =20