X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_main%2FSearch.pm;h=b899c713c09a3f24864e601b8c0d30e61215f032;hp=2460250a6b231cf761d272b2337271237ff60be0;hb=642a10f62a0c0ac6c4150ef11076666d88fe8a90;hpb=922f9f7ee1ff081a4098d49449c63043d551897f diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index 2460250a6..b899c713c 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -383,6 +383,7 @@ sub smart_search { if ( $conf->exists('address1-search') && length($value) >= $min_len ) { push @cust_main, qsearch( { + select => 'cust_main.*', table => 'cust_main', addl_from => 'JOIN cust_location USING (custnum)', extra_sql => 'WHERE '.