X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_svc.pm;fp=FS%2FFS%2Fcust_svc.pm;h=376ef026378c91840f196c3544aa307ca7868f5f;hp=974af67439df71be3065167e3ecb170702b38d14;hb=212dee7b6078fc6a9dff3469b07274da5b1e905e;hpb=b8fc5d2178e7358661e37ef97b7619f7a9080f3a diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm index 974af6743..376ef0263 100644 --- a/FS/FS/cust_svc.pm +++ b/FS/FS/cust_svc.pm @@ -1205,9 +1205,10 @@ sub smart_search_param { my @or = map { my $table = $_; my $search_sql = "FS::$table"->search_sql($string); + my $addl_from = "FS::$table"->search_sql_addl_from(); "SELECT $table.svcnum AS svcnum, '$table' AS svcdb ". - "FROM $table WHERE $search_sql"; + "FROM $table $addl_from WHERE $search_sql"; } FS::part_svc->svc_tables;