diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-08-06 16:21:47 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-08-06 16:30:46 -0400 |
| commit | 3da875870fc86799f4d1c5990260840e44337590 (patch) | |
| tree | 6b7159ab8ccd719d913bfbeec27103d54477d429 | |
| parent | 12ce18dfa572fabaac35e3d11a905a46095de3b4 (diff) | |
RT# 77160 - fixed sql when joing cust_location
| -rw-r--r-- | httemplate/search/cust_timespan.html | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/httemplate/search/cust_timespan.html b/httemplate/search/cust_timespan.html index 13fc6a1ab..53ee66d42 100644 --- a/httemplate/search/cust_timespan.html +++ b/httemplate/search/cust_timespan.html @@ -101,8 +101,6 @@ my @fields = ( 'custnum', 'custname', $location_sub, 'daytime', $email_sub, 'act my @links = ( $customer_link, $customer_link, '', '', '', '', '', '', '' ); my @select = ( 'cust_main.*', - 'cust_location.*', - 'part_pkg.*', "(select to_char((select to_timestamp((".$active_date."))), 'Mon DD YYYY')) AS active_date", "(select to_char((select to_timestamp((".$cancel_date."))), 'Mon DD YYYY')) AS cancel_date", "($cancel_reason) AS cancel_reason", |