diff options
| -rw-r--r-- | FS/FS/cust_svc.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm index cab80a8..6274107 100644 --- a/FS/FS/cust_svc.pm +++ b/FS/FS/cust_svc.pm @@ -870,7 +870,7 @@ sub smart_search_param { 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 ". |