Changeset 65425 in vbox for trunk/src/VBox

Timestamp:

Jan 24, 2017 3:01:05 PM (8 years ago)

Author:

vboxsync

Message:

testbox.py: Name sorting tweak.

File:

• trunk/src/VBox/ValidationKit/testmanager/core/testbox.py (modified) (1 diff)

trunk/src/VBox/ValidationKit/testmanager/core/testbox.py

@@ -690 +690 @@
     kdSortColumnMap                 = {
         0:                               'TestBoxesWithStrings.sName',
-        kiSortColumn_sName:              'TestBoxesWithStrings.sName',
-        -kiSortColumn_sName:             'TestBoxesWithStrings.sName DESC',
+        kiSortColumn_sName:              "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*','', 'g'), "\
+                                         "regexp_replace(CONCAT(TestBoxesWithStrings.sName,'0'),'[^0-9]*','', 'g')::int",
+        -kiSortColumn_sName:             "regexp_replace(TestBoxesWithStrings.sName,'[0-9]*','', 'g') DESC, "\
+                                         "regexp_replace(CONCAT(TestBoxesWithStrings.sName,'0'),'[^0-9]*','', 'g')::int DESC",
         kiSortColumn_sOs:                'TestBoxesWithStrings.sOs',
         -kiSortColumn_sOs:               'TestBoxesWithStrings.sOs DESC',