From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 4 Mar 2022 04:23:32 +0000 (-0800)
Subject: fix 477 deployment report
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=8e635ac832696698fab3299f68acf0f58781c248

fix 477 deployment report
---

diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm
index 0f5d4cedc..3749bfebe 100644
--- a/FS/FS/Report/FCC_477.pm
+++ b/FS/FS/Report/FCC_477.pm
@@ -382,7 +382,8 @@ sub fbd_sql {
   );
   push @where, "agentnum = $agentnum" if $agentnum;
 
-  my $order_by = 'censusblock, agentnum, technology, is_consumer, is_business';
+  #my $order_by = 'censusblock, agentnum, technology, is_consumer, is_business';
+  my $order_by = 'censusblock, technology';
 
   "SELECT DISTINCT ".join(', ', @select) . "
   FROM $from