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

From OpenWetWare

< DataONE:Notebook | Piwowar Notes | 2010 | 08(Difference between revisions)
Jump to: navigation, search
(initial plans content)
Current revision (12:09, 3 August 2010) (view source)
(add note about dynamic nature of todo list)
 
(7 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%20A,B%20where%20A%20contains%20'2010-08-02'&key=t_LXM5f_pFxk9p0dFwXp0cA#gid=0" style="height:300px;width:450px;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==
 +
 +
===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==
==Relevant background life==

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