DataONE:Notebook/Piwowar Notes/2010/08/02
From OpenWetWare
(Difference between revisions)
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
NotesEmbedding query subsets of google spreadsheets in OWW
Relevant background life
| |
