diff options
| author | ivan <ivan> | 2009-09-23 23:47:47 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-09-23 23:47:47 +0000 |
| commit | 61cd6f69bdd692aa08de2ab1a2f19a457c46a7bb (patch) | |
| tree | 6c4e1bf65bcf7db96f0537193e42443d984b07d7 | |
| parent | aa0ce82aa8d9c19dc431ce66dc3f46982431c743 (diff) | |
this should fix the occasional extra ticket showing up on wrong customer record
| -rw-r--r-- | FS/FS/TicketSystem/RT_External.pm | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm index c7a756bde..c60aa66e1 100644 --- a/FS/FS/TicketSystem/RT_External.pm +++ b/FS/FS/TicketSystem/RT_External.pm @@ -154,14 +154,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 ); |