DataONE:Notebook/Piwowar Notes/2010/08/02: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
(Autocreate 2010/08/02 Entry for DataONE:Notebook/Piwowar_Notes) |
(fix raw html notebook nav) |
||
(9 intermediate revisions by one other user not shown) | |||
Line 2: | Line 2: | ||
|- | |- | ||
|style="background-color: #EEE"|[[Image:owwnotebook_icon.png|12px]]<span style="font-size:22px;"> [[User:Heather_A_Piwowar|Heather Piwowar]]'s notes</span> | |style="background-color: #EEE"|[[Image:owwnotebook_icon.png|12px]]<span style="font-size:22px;"> [[User:Heather_A_Piwowar|Heather Piwowar]]'s notes</span> | ||
|style="background-color: #F2F2F2" align="center"| | |style="background-color: #F2F2F2" align="center"|[[File:Report.png|frameless|link={{#sub:{{FULLPAGENAME}}|0|-11}}]][[{{#sub:{{FULLPAGENAME}}|0|-11}}|Main project page]]<br />{{#if:{{#lnpreventry:{{FULLPAGENAME}}}}|[[File:Resultset_previous.png|frameless|link={{#lnpreventry:{{FULLPAGENAME}}}}]][[{{#lnpreventry:{{FULLPAGENAME}}}}{{!}}Previous entry]] }}{{#if:{{#lnnextentry:{{FULLPAGENAME}}}}|[[{{#lnnextentry:{{FULLPAGENAME}}}}{{!}}Next entry]][[File:Resultset_next.png|frameless|link={{#lnnextentry:{{FULLPAGENAME}}}}]]}} | ||
|- | |- | ||
| colspan="2"| | | colspan="2"| | ||
<!-- ##### DO NOT edit above this line unless you know what you are doing. ##### --> | <!-- ##### DO NOT edit above this line unless you know what you are doing. ##### --> | ||
[[Category:DataONE]] | [[Category:DataONE]] | ||
==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=== | |||
* 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== | |||
* BC Day today, so UBC and most of Vancouver is closed. Working from coffee shops | |||
Latest revision as of 19:24, 26 September 2017
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) <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 NotesEmbedding query subsets of google spreadsheets in OWW
Relevant background life
|