X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Ftimeworked.html;h=bbfd0334d2e1bc4fc29a99e15ff0d5900b73d19e;hb=aba86d4205a831c561fcf62a24d021c82c229d96;hp=e810822d7af5bf3dc46480039bc2ed5b9f983b2f;hpb=bd9ef4c4ca8644f99c1fcc595212f6a5c6787fc5;p=freeside.git diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html index e810822d7..bbfd0334d 100644 --- a/httemplate/search/timeworked.html +++ b/httemplate/search/timeworked.html @@ -78,9 +78,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' + OR Transactions.Type IN ( 'Create', 'Comment', 'Correspond', 'Touch' ) ) AND $wheretimeleft ";