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:21:47 -0400 |
| commit | f8c83f3becbd2792eba93c9f87d6c1e4f03414cf (patch) | |
| tree | ff34011719de4b57c76567ede71210e0825b5985 | |
| parent | 7f708b4460270a0651b4bab1e7f598728b04690d (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", |