Template:Resultlink: Difference between revisions

From Opasnet
Jump to navigation Jump to search
(upload condition added to full sample as well)
No edit summary
 
(30 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 
  {{#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, 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}}
 
<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

{{#opasnet_base_link:Op_en2239}}

USAGE:
This template creates a link to a variable in result database.
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.

Retrieved from "https://en.opasnet.org/index.php?title=Template:Resultlink&oldid=16767"