couchdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Couchdb Wiki] Update of "Views_for_Lotus_Geeks" by AlanBell
Date Fri, 01 Jan 2010 10:47:13 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Couchdb Wiki" for change notification.

The "Views_for_Lotus_Geeks" page has been changed by AlanBell.
http://wiki.apache.org/couchdb/Views_for_Lotus_Geeks

--------------------------------------------------

New page:
CouchDB and Lotus Notes are both document databases with many similarities in terms of the
data model and the way views work. Many of the best practices and limitations are the same
for each, but there is new terminology to learn and some pretty powerful extra things you
can do in CouchDB.

== A simple view ==
For this example lets assume we have a database of task documents

Form:"Task"
Priority:"Medium"
Subject:"Service Car"
Created:"2009-12-31T19:51:22"

Form:"Task"
Priority:"High"
Subject:"Book restaurant for mum's birthday"
Created:"2009-12-31T19:51:29"

Form:"Task"
Priority:"Medium"
Subject:"Return library books"
Created:"2010-01-01T08:31:49"

so the first thing to notice is that the Created field is in a funny format for Notes, this
is ISO format datetime string, it sorts nicely as text and works well in Python and Javascript
and in fact pretty much every language but Lotusscript. We will come back to times and dates
in views later, but one thing worth mentioning is that you don't use the current time in a
couchdb view formula just like you don't use @now in a view selection or column formula for
exactly the same reason.

Mime
View raw message