for our internal time tracking: TimeWorked can happen on a Create transaction as...

diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html
index 31ad10d..651f289 100644 (file)
--- a/httemplate/search/rt_transaction.html
+++ b/httemplate/search/rt_transaction.html
@@ -54,7 +54,7 @@ my $where = "
     AND (    ( Transactions.Type = 'Set'
                AND Transactions.Field = 'TimeWorked'
                AND Transactions.NewValue != Transactions.OldValue )
-          OR ( ( Transactions.Type='Comment' OR Transactions.Type='Correspond' )
+          OR ( ( Transactions.Type='Create' OR Transactions.Type='Comment' OR Transactions.Type='Correspond' )
                AND Transactions.TimeTaken > 0
              )
         )

diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html
index 49173bd..b72dd0e 100644 (file)
--- a/httemplate/search/timeworked.html
+++ b/httemplate/search/timeworked.html
@@ -88,6 +88,7 @@ my $groupby = join(',', @groupby);
 my $where = "
   WHERE ObjectType='RT::Ticket'
     AND ( ( Transactions.Type='Set' AND Field='TimeWorked' )
+          OR Transactions.Type='Create'
           OR Transactions.Type='Comment'
           OR Transactions.Type='Correspond'
         )