Template:Resultlink: Difference between revisions
(Locations added to the mean view) |
mNo edit summary |
||
| Line 14: | Line 14: | ||
SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations | SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations | ||
FROM Loccell, Loc, | FROM Loccell, Loc, | ||
(SELECT Var.Ident, Var.Name, Cell.id, Run.id as | (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 | FROM Obj as Var, Obj as Run, Cell, Objinfo | ||
WHERE Var.Ident = "Op_en{{PAGEID}}" | WHERE Var.Ident = "Op_en{{PAGEID}}" | ||
| Line 24: | Line 24: | ||
AND Loc.id = Loccell.Loc_id | AND Loc.id = Loccell.Loc_id | ||
GROUP BY Temp.id | GROUP BY Temp.id | ||
ORDER BY | ORDER BY Upload DESC | ||
|Cell means and samplesizes (N)}} | | |Cell means and samplesizes (N)}} | | ||
{{#sql-query: | {{#sql-query: | ||
Revision as of 14:02, 21 April 2009
Show results from the Opasnet Base:
{{#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_en2239" 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 |List of uploads}} | The newest upload | {{#sql-query: SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations FROM Loccell, 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_en2239" AND Var.id = Cell.Obj_id_v AND Run.id = Cell.Obj_id_r AND Run.id = Objinfo.Obj_id 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 Var.Ident, Cell.id, Cell.Obj_id_r as Run, Obs, Result, Var.Unit FROM Obj as Var, Cell, Res WHERE Var.Ident = "Op_en2239" AND Var.id = Cell.Obj_id_v AND Cell.id = Res.Cell_id ORDER BY Cell.Obj_id_r, Var.Ident, Cell.id |Full sample}}
USAGE:
This template creates a link to a variable in result database.
First parameter is number of samples.
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.