[dev] enhancement to Kernel/System/Ticket.pm

[Wiktor Wodecki]

Hi there,

this minor enhancement to Kernel/System/Ticket.pm allows the generic
agent to use decision constraints based on changetime.

This is useful in automatic state changes scenarios where you'd want to
escalate things.

Please consider to apply.


--- Ticket.pm.orig      2007-02-27 15:21:58.000000000 +0100
+++ Ticket.pm   2007-02-27 15:22:31.000000000 +0100
@@ -2660,6 +2660,10 @@
             $SQLExt .= " AND st.until_time >=
'".$Self->{DBObject}->Quote($Param{TicketPendingTimeNewerDate})."'";
         }
     }
+    # get tickets changed more than x minutes ago
+    if ($Param{TicketChangeTimeOlder}) {
+        $SQLExt .= " AND st.change_time < NOW() - interval
'".$Param{TicketChangeTimeOlder}."'";
+    }
     # database query
     $SQLExt .= " ORDER BY $SortOptions{$SortBy}";
     if ($OrderBy eq 'Up') {

-- 
Regards,

 Wiktor Wodecki

 net mobile AG, Zollhof 17, 40221 Duesseldorf, Germany
 923B DCF8 070C 9FDD 5E05  9AE3 E923 5A35 182C 9783

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.otrs.org/pipermail/dev/attachments/20070227/73a6e027/signature.pgp