From 1313896e5b0cd551fc4449fe6dd8c863d5d1de4a Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Thu, 26 May 2016 12:11:56 -0700 Subject: [PATCH] #41670, backporting fix --- rt/lib/RT/Search/UnrepliedTickets.pm | 23 +++++++++++++++++------ 1 file changed, 17 insertions(+), 6 deletions(-) diff --git a/rt/lib/RT/Search/UnrepliedTickets.pm b/rt/lib/RT/Search/UnrepliedTickets.pm index a99690156..611675a66 100644 --- a/rt/lib/RT/Search/UnrepliedTickets.pm +++ b/rt/lib/RT/Search/UnrepliedTickets.pm @@ -30,28 +30,39 @@ sub Prepare { my $self = shift; my $TicketsObj = $self->TicketsObj; - $TicketsObj->Limit( + # bypass the pre-RT-4.2 TicketRestrictions stuff and just use SearchBuilder + $TicketsObj->RT::SearchBuilder::Limit( FIELD => 'Owner', VALUE => $TicketsObj->CurrentUser->id ); - $TicketsObj->Limit( + $TicketsObj->RT::SearchBuilder::Limit( FIELD => 'Status', OPERATOR => '!=', VALUE => 'resolved' ); my $txn_alias = $TicketsObj->JoinTransactions; - $TicketsObj->Limit( + $TicketsObj->RT::SearchBuilder::Limit( ALIAS => $txn_alias, FIELD => 'Created', OPERATOR => '>', VALUE => 'COALESCE(main.Told,\'1970-01-01\')', QUOTEVALUE => 0, ); - $TicketsObj->Limit( + $TicketsObj->RT::SearchBuilder::Limit( ALIAS => $txn_alias, FIELD => 'Type', - OPERATOR => 'IN', - VALUE => [ 'Correspond', 'Create' ], + OPERATOR => '=', + VALUE => 'Correspond', + SUBCLAUSE => 'transactiontype', + ENTRYAGGREGATOR => 'OR', + ); + $TicketsObj->RT::SearchBuilder::Limit( + ALIAS => $txn_alias, + FIELD => 'Type', + OPERATOR => '=', + VALUE => 'Create', + SUBCLAUSE => 'transactiontype', + ENTRYAGGREGATOR => 'OR', ); return(1); -- 2.11.0