Difference between revisions of "DataONE:Notebook/Piwowar Notes/2010/08/02"

From OpenWetWare
Jump to: navigation, search
(Plans and accomplishments: add done, notes column)
(add note about dynamic nature of todo list)
(3 intermediate revisions by the same user 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,D,E%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

Revision as of 09:09, 3 August 2010

Owwnotebook icon.png Heather Piwowar's notes <html><img src="/images/9/94/Report.png" border="0" /></html> Main project page
<html><img src="/images/c/c3/Resultset_previous.png" border="0" /></html>Previous entry<html>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</html>Next entry<html><img src="/images/5/5c/Resultset_next.png" border="0" /></html>


Plans and accomplishments

(Note that as things left undone are assigned new dates, they disappear from this list) <html> <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> 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