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

index 033d8ea..b8fdbec 100644 (file)
@@ -421,6 +421,13 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
                 
                    
             }
+            $et->selectAdd("
+                CASE WHEN etype= 'ticketstate' THEN
+                    name
+                ELSE
+                    CONCAT('CLOSED - ', name)
+                END AS name_prefixed
+                           ");
             
             
             $et->orderBy("ts_order ASC");