Template:Resultlink: Difference between revisions

From Opasnet
Jump to navigation Jump to search
(mean query made quicker (70 ms with testvariable vs 450 ms with old))
No edit summary
 
(11 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|{{PAGENAME}}}} |
[http://base.opasnet.org/index.php?page_id={{PAGEID}}&wiki_id=1&sample={{{1|1}}} The newest upload] |
{{#sql-query:
SELECT Cell.Obj_id_v AS Object, Cell_id AS Cell, Cell.Obj_id_r AS Upload, Obj.Ident, Obj.Name, N, GROUP_CONCAT(Loc.Location SEPARATOR ', ') AS Location, Obj.Unit, Mean, SD
FROM (SELECT Obj_id_v, Obj_id_r FROM Obj JOIN Cell ON Obj.id=Cell.Obj_id_v WHERE Obj.Ident="Op_en{{PAGEID}}" GROUP BY Obj_id_r DESC LIMIT 0,1) AS Newest, Obj
JOIN Cell ON Obj.id=Cell.Obj_id_v
JOIN Loccell ON Cell.id=Loccell.Cell_id
JOIN Loc AS Rawloc ON Loccell.Loc_id=Rawloc.id
JOIN Loc ON Rawloc.Std_id=Loc.id
JOIN Obj AS Ind ON Loc.Obj_id_i=Ind.id
WHERE Obj.Ident="Op_en{{PAGEID}}"
AND Cell.Obj_id_r={{#if: {{{upload|}}}|{{{upload}}}|Newest.Obj_id_r}}
GROUP BY Cell_id LIMIT 0, 1000
|Mean and SD}} |
{{#sql-query:
SELECT Temp.*, Res.Obs, Res.Result
FROM  (SELECT Cell.Obj_id_v AS Object, Cell_id AS Cell, Cell.Obj_id_r AS Upload, Obj.Ident, Obj.Name, N, GROUP_CONCAT(Loc.Location SEPARATOR ', ') AS Location, Obj.Unit, Mean, SD FROM Obj
JOIN (SELECT Obj_id_v, MAX(Obj_id_r) AS Obj_id_r FROM
(SELECT * FROM Cell
GROUP BY Obj_id_v, Obj_id_r) AS Temp
GROUP BY Obj_id_v) AS Newest ON Obj.id=Newest.Obj_id_v
JOIN Cell ON Obj.id=Cell.Obj_id_v
JOIN Loccell ON Cell.id=Loccell.Cell_id
JOIN Loc AS Rawloc ON Loccell.Loc_id=Rawloc.id
JOIN Loc ON Rawloc.Std_id=Loc.id
JOIN Obj AS Ind ON Loc.Obj_id_i=Ind.id
WHERE Obj.Ident="Op_en{{PAGEID}}"
AND Cell.Obj_id_r={{#if: {{{upload|}}}|{{{upload}}}|Newest.Obj_id_r}}
GROUP BY Cell_id) AS Temp
JOIN Res ON Temp.Cell=Res.Cell_id
WHERE Obs<101
LIMIT 0, 1000
|Sample (max 100 iterations)}}
<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.