From 1591e861f33cd2920e6af6fb118c173f6806be76 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 12 Feb 2008 19:24:12 +0000 Subject: [PATCH] for our internal time tracking: TimeWorked can happen on a Create transaction as well as Correspond and Comment. is there anywhere else this needs to be changed? --- httemplate/search/rt_transaction.html | 2 +- httemplate/search/timeworked.html | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html index 31ad10d1a..651f2896d 100644 --- 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 49173bd08..b72dd0ea9 100644 --- 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' ) -- 2.11.0