fix phantom customer links, RT#13852
authorIvan Kohler <ivan@freeside.biz>
Tue, 3 Jul 2012 19:47:36 +0000 (12:47 -0700)
committerIvan Kohler <ivan@freeside.biz>
Tue, 3 Jul 2012 19:47:36 +0000 (12:47 -0700)
rt/lib/RT/Tickets.pm

index bfc8e56..485d7df 100755 (executable)
@@ -2084,7 +2084,12 @@ sub JoinToCustLinks {
             TABLE2 => 'Links',
             FIELD2 => 'LocalBase',
         );
-
+       $self->SUPER::Limit(
+         LEFTJOIN => $linkalias,
+         FIELD    => 'Base',
+         OPERATOR => 'LIKE',
+         VALUE    => 'fsck.com-rt://%/ticket/%',
+       );
         $self->SUPER::Limit(
             LEFTJOIN => $linkalias,
             FIELD    => 'Type',
@@ -2134,6 +2139,12 @@ sub JoinToSvcLinks {
             TABLE2 => 'Links',
             FIELD2 => 'LocalBase',
         );
+       $self->SUPER::Limit(
+         LEFTJOIN => $linkalias,
+         FIELD    => 'Base',
+         OPERATOR => 'LIKE',
+         VALUE    => 'fsck.com-rt://%/ticket/%',
+       );
 
         $self->SUPER::Limit(
             LEFTJOIN => $linkalias,