FS::part_svc->svc_tables;
if ( $string =~ /^(\d+)$/ ) {
- unshift @or, "SELECT cust_svc.svcnum, NULL FROM cust_svc WHERE agent_svcid = $1";
+ unshift @or, "SELECT cust_svc.svcnum, NULL as svcdb FROM cust_svc WHERE agent_svcid = $1";
}
my $addl_from = " RIGHT JOIN (\n" . join("\nUNION\n", @or) . "\n) AS svc_all ".
(
'table' => 'cust_svc',
'select' => 'svc_all.svcnum AS svcnum, '.
- 'COALESCE(svc_all.svcdb, part_svc.svcdb) AS svcdb',
+ 'COALESCE(svc_all.svcdb, part_svc.svcdb) AS svcdb, '.
+ 'cust_svc.*',
'addl_from' => $addl_from,
'hashref' => {},
'extra_sql' => $extra_sql,