diff options
| -rw-r--r-- | FS/FS/TicketSystem/RT_External.pm | 4 |
1 files changed, 3 insertions, 1 deletions
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"; |