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

index aaf49b0..3c65a7b 100644 (file)
@@ -421,9 +421,9 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
             }
             $et->selectAdd("
                 CASE WHEN etype= 'ticketstate' THEN
-                    name
+                    LOWER(REPLACE(name, '_', ' '))
                 ELSE
-                    CONCAT('CLOSED - ', name)
+                    CONCAT('closed - ', LOWER(REPLACE(name, '_', ' ')))
                 END AS name_mixed
             ");