Difference between revisions of "Template:Resultlink"

From Testiwiki
Jump to: navigation, search
(restext added to full sample query)
 
(32 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}}}}
−
 
 
−
{{#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, 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 
 
−
  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, 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
 
−
  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}}
 
−
 
 
 
<noinclude>
 
<noinclude>
 
'''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>

Latest revision as of 11:57, 14 July 2010


USAGE:
This template creates a link to a variable in result database.
First parameter is number of samples.

Just testing:

Show results

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.

Retrieved from "http://www.opasnet.org/testiwiki/index.php?title=Template:Resultlink&oldid=16767"