diff options
| author | mark <mark> | 2011-10-24 22:50:47 +0000 |
|---|---|---|
| committer | mark <mark> | 2011-10-24 22:50:47 +0000 |
| commit | 53c18558abf77ea27c56dc51c5ca40a80e0d35ab (patch) | |
| tree | b20a64aae77f0af1b3fb9c378670fb920bce323e /httemplate | |
| parent | 729a3c80385332bd26f62024e5d955d58d1eb9e3 (diff) | |
record support time even without comment text, #14837
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/rt_ticket.html | 2 | ||||
| -rw-r--r-- | httemplate/search/rt_transaction.html | 8 |
2 files changed, 5 insertions, 5 deletions
diff --git a/httemplate/search/rt_ticket.html b/httemplate/search/rt_ticket.html index 7ffe55fc1..abe13157d 100644 --- a/httemplate/search/rt_ticket.html +++ b/httemplate/search/rt_ticket.html @@ -67,7 +67,7 @@ my $twhere = " AND ( ( Transactions.Type = 'Set' AND Transactions.Field = 'TimeWorked' AND Transactions.NewValue != Transactions.OldValue ) - OR ( ( Transactions.Type='Create' OR Transactions.Type='Comment' OR Transactions.Type='Correspond' ) + OR ( ( Transactions.Type='Create' OR Transactions.Type='Comment' OR Transactions.Type='Correspond' OR Transactions.Type='Touch' ) AND Transactions.TimeTaken > 0 ) ) diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html index ab5636347..be9cd0bc9 100644 --- a/httemplate/search/rt_transaction.html +++ b/httemplate/search/rt_transaction.html @@ -47,9 +47,9 @@ die "access denied" #some amount of false laziness w/timeworked.html... my $transactiontime = " - CASE transactions.type when 'Set' - THEN (to_number(newvalue,'999999')-to_number(oldvalue, '999999')) * 60 - ELSE timetaken*60 + CASE Transactions.Type when 'Set' + THEN (to_number(NewValue,'999999')-to_number(OldValue, '999999')) * 60 + ELSE TimeTaken*60 END "; @@ -62,7 +62,7 @@ my $where = " AND ( ( Transactions.Type = 'Set' AND Transactions.Field = 'TimeWorked' AND Transactions.NewValue != Transactions.OldValue ) - OR ( ( Transactions.Type='Create' OR Transactions.Type='Comment' OR Transactions.Type='Correspond' ) + OR ( ( Transactions.Type='Create' OR Transactions.Type='Comment' OR Transactions.Type='Correspond' OR Transactions.Type='Touch' ) AND Transactions.TimeTaken > 0 ) ) |