Difference between revisions of "Standard run"

From Testiwiki
Jump to: navigation, search
(first draft based on own thinking)
 
(query corrected)
Line 5: Line 5:
 
List all standard runs:
 
List all standard runs:
 
<sql-query>
 
<sql-query>
SELECT Obj.id, Obj.Ident, Obj.Name, Descr.Who, Descr.Date
+
SELECT Obj.id, Ident, Name, Who,
FROM Obj JOIN Descr ON Obj.id = Descr.id
+
BEGIN FROM Obj
WHERE Wik_id = 1
+
LEFT JOIN Inf ON Obj.id = Inf.id
AND Page = 2816
+
WHERE Wik_id =1
 +
AND Page =2817
 
</sql-query>
 
</sql-query>
  

Revision as of 12:52, 13 February 2009

Standard run is such a run of a model that contains no special information in addition to what is found from the Opasnet base. It therefore does not need any specific page in Opasnet, and this page is used to describe all standard runs.


List all standard runs: <sql-query> SELECT Obj.id, Ident, Name, Who, BEGIN FROM Obj LEFT JOIN Inf ON Obj.id = Inf.id WHERE Wik_id =1 AND Page =2817 </sql-query>

See also