fix bug with duplicate tickets showing up on customer view listing when the custom...

[freeside.git] / FS / FS / TicketSystem / RT_External.pm

diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm
index f94e791..667f0dc 100644 (file)
--- a/FS/FS/TicketSystem/RT_External.pm
+++ b/FS/FS/TicketSystem/RT_External.pm
@@ -86,7 +86,8 @@ sub _from_customer {
                     ON ( CustomFields.id = ObjectCustomFields.CustomField )
          WHERE LookupType = 'RT::Queue-RT::Ticket'
            AND name = ?
-           AND ( $queue_sql )";
+           AND ( $queue_sql )
+       )";
 
     push @param, $priority_field,
                  $priority_field_queue,
@@ -108,6 +109,7 @@ sub _from_customer {
                  ON ( tickets.id = ObjectCustomFieldValues.ObjectId )";
       
       $where = " AND content = ?
+                 AND disabled != 1
                  AND ObjectType = 'RT::Ticket'
                  AND $customfield_sql";