diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-08-06 16:21:47 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-08-06 18:37:26 -0400 |
| commit | 771e93f4139a07e2324797f2b3a2f5bd1dc57aa5 (patch) | |
| tree | 2882cb5ffbb7782ea505de4ab326f1b8d32a28dc | |
| parent | 8c3b59c96ccd10592fb3d176ae1ad54c30b553df (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 f95250a44..a511a30a5 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", |