From 3da875870fc86799f4d1c5990260840e44337590 Mon Sep 17 00:00:00 2001 From: Christopher Burger Date: Mon, 6 Aug 2018 16:21:47 -0400 Subject: [PATCH] RT# 77160 - fixed sql when joing cust_location --- httemplate/search/cust_timespan.html | 2 -- 1 file changed, 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", -- 2.11.0