DataONE:Notebook/Piwowar Notes/2010/08/02

{| width="800"
 * style="background-color: #EEE"|[[Image:owwnotebook_icon.png|12px]] Heather Piwowar's notes
 * style="background-color: #F2F2F2" align="center"|  |Main project page
 * style="background-color: #F2F2F2" align="center"|  |Main project page


 * colspan="2"|
 * colspan="2"|

Plans and accomplishments
(Note that as things left undone are assigned new dates, they disappear from this list)   Raw spreadsheet: http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en

Embedding query subsets of google spreadsheets in OWW

 * Spreadsheet itself: http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en
 * URL to get the subset shown above: http://spreadsheets.google.com/tq?tqx=out:html&tq=select%20B,C,D,E%20where%20B%20contains%20'2010-08-02'&key=t_LXM5f_pFxk9p0dFwXp0cA#gid=0
 * the where clause can contain:
 * contains, matches, <, >, =, !
 * Select by name (case sensitive); 'matches' must match exactly, 'contains' is a free text search
 * Useful post: http://blog.ouseful.info/2009/05/18/?orderby=ID&order=ASC
 * Query builder: http://ouseful.open.ac.uk/datastore/gspreadsheetdb2.php
 * To filter on dates, use this format: where A contains '2010-08-02'

Relevant background life

 * BC Day today, so UBC and most of Vancouver is closed. Working from coffee shops


 * }