diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2018-08-01 13:32:33 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2018-08-01 13:32:33 -0700 |
| commit | adc262be7fc31d50a06a6ef11e5d1767dbf94bb4 (patch) | |
| tree | 27f0d63476071d8d7d552dcd972c72f620b03d17 | |
| parent | 256a21d5c84739f0f5d3456a38a08d04f1f8a5fd (diff) | |
fix search failures, RT#77532
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index 2ec87cd14..e0ca450e1 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -95,6 +95,7 @@ sub smart_search { #cust_main phone numbers and contact phone number push @cust_main, qsearch( { + 'select' => 'cust_main.*', 'table' => 'cust_main', 'hashref' => { %options }, 'extra_sql' => ( scalar(keys %options) ? ' AND ' : ' WHERE ' ). @@ -131,6 +132,7 @@ sub smart_search { if ( $search =~ /@/ ) { #email address from cust_main_invoice and contact_email push @cust_main, qsearch( { + 'select' => 'cust_main.*', 'table' => 'cust_main', 'hashref' => { %options }, 'extra_sql' => ( scalar(keys %options) ? ' AND ' : ' WHERE ' ). @@ -282,7 +284,7 @@ sub smart_search { #cust_main and contacts push @cust_main, qsearch( { 'table' => 'cust_main', - 'select' => 'cust_main.*, cust_contact.*, contact.contactnum, contact.last as contact_last, contact.first as contact_first, contact.title', + 'select' => 'cust_main.*', 'hashref' => { %options }, 'extra_sql' => "$sql AND $agentnums_sql", #agent virtualization 'addl_from' => ' left join cust_contact on cust_main.custnum = cust_contact.custnum left join contact using (contactnum) ', @@ -314,7 +316,7 @@ sub smart_search { push @cust_main, qsearch( { 'table' => 'cust_main', - 'select' => 'cust_main.*, cust_contact.*, contact.contactnum, contact.last as contact_last, contact.first as contact_first, contact.title', + 'select' => 'cust_main.*', 'hashref' => { %options }, 'extra_sql' => "$sql AND $agentnums_sql", #agent virtualization 'addl_from' => 'left join cust_contact on cust_main.custnum = cust_contact.custnum left join contact using (contactnum) ', |