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

From OpenWetWare

< DataONE:Notebook | Piwowar Notes | 2010 | 08(Difference between revisions)
Jump to: navigation, search
m (Plans and accomplishments: changed columns)
Current revision (12:09, 3 August 2010) (view source)
(add note about dynamic nature of todo list)
 
(4 intermediate revisions not shown.)
Line 10: Line 10:
==Plans and accomplishments==
==Plans and accomplishments==
 +
(Note that as things left undone are assigned new dates, they disappear from this list)
<html>
<html>
-
<div style="padding:0;margin:0;text-align:left"><iframe src="http://spreadsheets.google.com/tq?tqx=out:html&tq=select%20B,C%20where%20B%20contains%20'2010-08-02'&key=t_LXM5f_pFxk9p0dFwXp0cA#gid=0" style="border:none;"></iframe><hr style="border:1px solid #E0E0E0;margin:0px 0px 5px 0px;padding:0;width:450px;"/></div>
+
<div style="padding:0;margin:0;text-align:left"><iframe src="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" style="width:100%;border:none;"></iframe><hr style="border:1px solid #E0E0E0;margin:0px 0px 5px 0px;padding:0;width:450px;"/></div>
</html>
</html>
 +
Raw spreadsheet:  http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en
==Notes==
==Notes==
Line 18: Line 20:
===Embedding query subsets of google spreadsheets in OWW===
===Embedding query subsets of google spreadsheets in OWW===
* 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
 +
* 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

Current revision

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


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

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