Changeset 86938 in vbox

Timestamp:

Nov 20, 2020 3:37:27 PM (4 years ago)

Author:

vboxsync

Message:

testmanager/status.py: Fixes.

File:

• trunk/src/VBox/ValidationKit/testmanager/cgi/status.py (modified) (2 diffs)

trunk/src/VBox/ValidationKit/testmanager/cgi/status.py

@@ -326 +326 @@
         TestBoxesWithStrings.sOS,
         SchedGroupNames.sSchedGroupNames
-FROM    TestBoxesWithStrings,
-        (SELECT TestBoxesInSchedGroups.idTestBox AS idTestBox,
+FROM    (SELECT TestBoxesInSchedGroups.idTestBox AS idTestBox,
                 STRING_AGG(SchedGroups.sName, ',') AS sSchedGroupNames
          FROM   TestBoxesInSchedGroups
@@ -335 +334 @@
             AND SchedGroups.tsExpire            = 'infinity'::TIMESTAMP
          GROUP BY TestBoxesInSchedGroups.idTestBox)
-        AS SchedGroupNames
+        AS SchedGroupNames,
+        TestBoxesWithStrings
 LEFT OUTER JOIN TestSets
              ON TestSets.idGenTestBox = TestBoxesWithStrings.idGenTestBox