|
|
| (25 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | Show results from the [[Opasnet base|Opasnet Base]]:
| + | {{#opasnet_base_link:Op_en{{PAGEID}}}} |
| − | | |
| − | Currently closed for maintenence
| |
| | <noinclude> | | <noinclude> |
| − | {{#sql-query:
| |
| − | SELECT Var.Ident, Var.Name, Var.Unit, Run.Ident, Objinfo.Moment, Objinfo.Who, Run.Name as Method
| |
| − | FROM Obj as Var, Obj as Run, Cell, Objinfo
| |
| − | WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| − | AND Var.id = Cell.Obj_id_v
| |
| − | AND Run.id = Cell.Obj_id_r
| |
| − | AND Run.id = Objinfo.Obj_id
| |
| − | GROUP BY Var.id, Run.id
| |
| − | ORDER BY Run.id DESC
| |
| − | |List of uploads}} |
| |
| − | [http://base.opasnet.org/index.php?page_id={{PAGEID}}&wiki_id=1&sample={{{1|1}}} The newest upload] |
| |
| − | {{#sql-query:
| |
| − | SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations
| |
| − | FROM Loccell, (SELECT Rawloc.id, Loc.Obj_id_i, Loc.Location, Loc.Roww, Loc.Description FROM Loc AS Rawloc, Loc WHERE Rawloc.Std_id = Loc.id) AS Loc,
| |
| − | (SELECT Var.Ident, Var.Name, Cell.id, Run.id as Upload, N, Objinfo.Moment, Mean, Var.Unit
| |
| − | FROM Obj as Var, Obj as Run, Cell, Objinfo
| |
| − | WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| − | AND Var.id = Cell.Obj_id_v
| |
| − | AND Run.id = Cell.Obj_id_r
| |
| − | AND Run.id = Objinfo.Obj_id
| |
| − | {{#if: {{{upload|}}}|AND Run.id = {{{upload}}}|}}
| |
| − | GROUP BY Cell.id ORDER BY Run.id DESC, Var.Ident) AS Temp
| |
| − | WHERE Temp.id = Loccell.Cell_id
| |
| − | AND Loc.id = Loccell.Loc_id
| |
| − | GROUP BY Temp.id
| |
| − | ORDER BY Upload DESC
| |
| − | |Cell means and samplesizes (N)}} |
| |
| − | {{#sql-query:
| |
| − | SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations
| |
| − | FROM Loccell, (SELECT Rawloc.id, Loc.Obj_id_i, Loc.Location, Loc.Roww, Loc.Description FROM Loc AS Rawloc, Loc WHERE Rawloc.Std_id = Loc.id) AS Loc,
| |
| − | (SELECT Var.Ident, Cell.id, Cell.Obj_id_r as Upload, Obs, Result, Var.Unit, Restext
| |
| − | FROM Obj as Var, Cell, Res
| |
| − | LEFT JOIN Resinfo ON Res.id = Resinfo.id
| |
| − | WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| − | AND Var.id = Cell.Obj_id_v
| |
| − | AND Cell.id = Res.Cell_id
| |
| − | {{#if: {{{upload|}}}|AND Cell.Obj_id_r = {{{upload}}}|}}
| |
| − | ORDER BY Cell.Obj_id_r, Var.Ident, Cell.id) AS Temp
| |
| − | WHERE Temp.id = Loccell.Cell_id AND Loc.id = Loccell.Loc_id
| |
| − | GROUP BY Temp.id, Obs ORDER BY Upload DESC
| |
| − | |Full sample}}
| |
| − |
| |
| − | {{#sql-query:
| |
| − | SELECT Var.Ident, Var.Name, Cell.id, Run.id, N, Objinfo.Moment, Mean, Var.Unit
| |
| − | FROM Obj AS Var, Obj AS Run, Cell, Objinfo
| |
| − | WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| − | AND Var.id = Cell.Obj_id_v
| |
| − | AND Run.id = Cell.Obj_id_r
| |
| − | AND Run.id = Objinfo.Obj_id
| |
| − | {{#if: {{{upload}}}|AND Run.id = {{{upload}}}|}}
| |
| − | ORDER BY Run.id DESC , Var.Ident
| |
| − | |Cell means without explanation}}
| |
| − |
| |
| − |
| |
| − |
| |
| | '''USAGE:'''<br> | | '''USAGE:'''<br> |
| | This template creates a link to a variable in result database.<br> | | This template creates a link to a variable in result database.<br> |
| | First parameter is number of samples. | | First parameter is number of samples. |
| | + | |
| | + | Just testing: |
| | + | |
| | + | {{#opasnet_base_link:Op_en1901}} |
| | | | |
| | Development idea: Templaatti avaa tuloksen uuteen ikkunaan. Siellä on linkki, jota klikkaamalla tulee compare versions muuttujan nykyisestä wikisivusta ja siitä, joka oli voimassa sillä hetkellä kun muuttuja laskettiin tulostietokantaan. | | Development idea: Templaatti avaa tuloksen uuteen ikkunaan. Siellä on linkki, jota klikkaamalla tulee compare versions muuttujan nykyisestä wikisivusta ja siitä, joka oli voimassa sillä hetkellä kun muuttuja laskettiin tulostietokantaan. |
| | [[op_fi:template:tuloslinkki]] | | [[op_fi:template:tuloslinkki]] |
| | </noinclude> | | </noinclude> |
Development idea: Templaatti avaa tuloksen uuteen ikkunaan. Siellä on linkki, jota klikkaamalla tulee compare versions muuttujan nykyisestä wikisivusta ja siitä, joka oli voimassa sillä hetkellä kun muuttuja laskettiin tulostietokantaan.
