diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2017-10-24 11:30:45 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2017-10-24 11:30:45 -0400 |
| commit | 5153c04218af1627d1e4e7c8216887fa3c54db7c (patch) | |
| tree | e6043abb7c2cd15e7df864f76bb2ec60d03663b1 /httemplate/search | |
| parent | 08ec0a26405eab73e9fe80632e788d9af4c76fe7 (diff) | |
RT# 77160 - updated query to not use cust_contact as that table does not exist in V3
Diffstat (limited to 'httemplate/search')
| -rw-r--r-- | httemplate/search/cust_timespan.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/cust_timespan.html b/httemplate/search/cust_timespan.html index a380b78ab..370b0b6ca 100644 --- a/httemplate/search/cust_timespan.html +++ b/httemplate/search/cust_timespan.html @@ -72,7 +72,7 @@ my $email_sub = sub { #can't because contactnum is in the wrong field #my @contact_email = $contact->contact_email; my @contact_email = qsearch({ table => 'contact_email', - addl_from => ' LEFT JOIN cust_contact ON (contact_email.contactnum = cust_contact.contactnum) LEFT JOIN cust_main ON (cust_contact.custnum = cust_main.custnum) ', + addl_from => ' LEFT JOIN contact ON (contact_email.contactnum = contact.contactnum) LEFT JOIN cust_main ON (contact.custnum = cust_main.custnum) ', extra_sql => ' WHERE cust_main.custnum = ' . $customer->custnum , } ); join('<br>', map $_->emailaddress, @contact_email); |