Template:Resultlink: Difference between revisions

From Opasnet
Jump to navigation Jump to search
(restext query removed because it doesn't work)
No edit summary
 
(5 intermediate revisions by the same user 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 AS Upload, Objinfo.Moment, Objinfo.Who, Run.Name as Method
FROM Obj AS Var
JOIN Cell ON Var.id = Cell.Obj_id_v
JOIN Obj AS Run ON Run.id = Cell.Obj_id_r
JOIN Objinfo ON Run.id = Objinfo.Obj_id
WHERE Var.Ident = "Op_en{{PAGEID}}"
GROUP BY Var.id, Run.id
ORDER BY Run.id DESC
|List of uploads|{{PAGENAME}}}} |
{{#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}}" ORDER 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, {{#if: {{{rows|}}}|{{{rows}}}|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 (SELECT Obj_id_v, Obj_id_r FROM Obj JOIN Cell ON Obj.id=Cell.Obj_id_v WHERE Obj.Ident="Op_en{{PAGEID}}" ORDER 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) AS Temp
JOIN Res ON Temp.Cell=Res.Cell_id
WHERE Obs<={{#if: {{{iterations|}}}|{{{iterations}}}|100}}
LIMIT 0, {{#if: {{{rows|}}}|{{{rows}}}|1000}}
|Sample (default 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.

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