Template:Assessments of the variable

From Opasnet
Jump to: navigation, search

{{#sql-query: SELECT Var.Ident as Variable, Assessment.*, Assessment.page AS Link FROM Obj as Var, Item, Sett, Obj as Assessment WHERE Var.id = Item.Obj_id AND Item.Sett_id = Sett.id AND Sett.Obj_id = Assessment.id AND Sty_id = 3 AND Var.Ident = "Op_en2704" |Show the assessments that use this variable}}

The idea is that Link contains an URL pointing to the assessment page, but somehow I cannot get this working.