From 345710417c36b3521bc44def48e1a85ece4ae4df Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 23 Sep 2009 23:47:25 +0000 Subject: [PATCH] this should fix the occasional extra ticket showing up on wrong customer record --- FS/FS/TicketSystem/RT_External.pm | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm index c788c03a1..8ccc93712 100644 --- a/FS/FS/TicketSystem/RT_External.pm +++ b/FS/FS/TicketSystem/RT_External.pm @@ -156,14 +156,16 @@ sub _from_customer { } my $sql = " - FROM Tickets - JOIN Queues ON ( Tickets.Queue = Queues.id ) - JOIN Links ON ( Tickets.id = Links.LocalBase ) - JOIN Users ON ( Tickets.Owner = Users.id ) - $join - WHERE ( ". join(' OR ', map "Status = '$_'", $self->statuses ). " ) - AND Target = 'freeside://freeside/cust_main/$custnum' - $where + FROM Tickets + JOIN Queues ON ( Tickets.Queue = Queues.id ) + JOIN Users ON ( Tickets.Owner = Users.id ) + JOIN Links ON ( Tickets.id = Links.LocalBase + AND Links.Base LIKE '%/ticket/' || Tickets.id ) + $join + + WHERE ( ". join(' OR ', map "Status = '$_'", $self->statuses ). " ) + AND Target = 'freeside://freeside/cust_main/$custnum' + $where "; ( $sql, @param ); -- 2.11.0