From 3b121dac62c91f6200c40ceb761a40b2e4e0db31 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 9 Dec 2004 12:18:32 +0000
Subject: [PATCH] narrow select to avoid pickup up wrong id field

---
 FS/FS/TicketSystem/RT_External.pm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm
index 5424a7122..204e7f41d 100644
--- a/FS/FS/TicketSystem/RT_External.pm
+++ b/FS/FS/TicketSystem/RT_External.pm
@@ -44,7 +44,9 @@ sub customer_tickets {
   #$dbh ||= create one from some config options
 
   my( $from_sql, @param) = $self->_from_customer( $custnum, $priority );
-  my $sql = "select * $from_sql order by priority desc limit $limit";
+  my $sql = "select tickets.*, queues.name".
+            ( length($priority) ? ", ticketcustomfieldvalues.content" : '' ).
+            " $from_sql order by priority desc limit $limit";
   my $sth = $dbh->prepare($sql) or die $dbh->errstr. "preparing $sql";
   $sth->execute(@param)         or die $sth->errstr. "executing $sql";
 
-- 
2.11.0