1 files changed, 14 insertions, 0 deletions
diff --git a/tsp/results-schema.sql b/tsp/results-schema.sql
index 7b40105..c47fb9a 100644
--- a/tsp/results-schema.sql
+++ b/tsp/results-schema.sql
@@ -43,3 +43,17 @@ CREATE VIEW IF NOT EXISTS currentstatus3 AS
     WHERE SR LIKE "%3.0-common%"
     ORDER BY SR DESC
 ;
+
+CREATE VIEW IF NOT EXISTS currentstatus4 AS
+    SELECT
+        test.tnumber AS "SR",
+        test.tdate AS "Date",
+        test.tbuildnr AS "Build nr",
+        device.dname AS "Device",
+        result.rname AS "Status"
+    FROM test
+    INNER JOIN device ON test.tdid = device.did
+    INNER JOIN result ON result.rid = test.trid
+    WHERE SR LIKE "%4.0-unified%"
+    ORDER BY SR DESC
+;