DataObjects/Mtrack_ticket.php
authorAlan Knowles <alan@roojs.com>
Wed, 30 Dec 2020 09:06:09 +0000 (17:06 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 30 Dec 2020 09:06:09 +0000 (17:06 +0800)
DataObjects/Mtrack_ticket.php

index 3c65a7b..ad2821f 100644 (file)
@@ -419,12 +419,19 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
                     break;
                  
             }
+            
             $et->selectAdd("
                 CASE WHEN etype= 'ticketstate' THEN
                     LOWER(REPLACE(name, '_', ' '))
                 ELSE
                     CONCAT('closed - ', LOWER(REPLACE(name, '_', ' ')))
-                END AS name_mixed
+                END AS name_mixed,
+                CASE WHEN etype= 'ticketstate' THEN
+                    display_name
+                ELSE
+                    CONCAT('closed - ', display_name)
+                END AS display_name_mixed
+                
             ");