[Couchdb Wiki] Update of "Views_for_Lotus_Geeks" by AlanBell

[Apache Wiki <wi...@apache.org>]

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.