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

From OpenWetWare

(Difference between revisions)
Jump to: navigation, search
m (Embedding query subsets of google spreadsheets in OWW: add selecting url)
(Embedding query subsets of google spreadsheets in OWW: more details on contains)
Line 19: Line 19:
* Spreadsheet itself:  http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en
* 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
* 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
* Useful post:  http://blog.ouseful.info/2009/05/18/?orderby=ID&order=ASC
* Query builder: http://ouseful.open.ac.uk/datastore/gspreadsheetdb2.php
* Query builder: http://ouseful.open.ac.uk/datastore/gspreadsheetdb2.php

Revision as of 12:54, 2 August 2010

Heather Piwowar's notes Main project page
Previous entry      Next entry


Plans and accomplishments


Notes

Embedding query subsets of google spreadsheets in OWW

Relevant background life

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



Personal tools