From 5153c04218af1627d1e4e7c8216887fa3c54db7c Mon Sep 17 00:00:00 2001 From: Christopher Burger Date: Tue, 24 Oct 2017 11:30:45 -0400 Subject: [PATCH] RT# 77160 - updated query to not use cust_contact as that table does not exist in V3 --- httemplate/search/cust_timespan.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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('
', map $_->emailaddress, @contact_email); -- 2.11.0