From 8e635ac832696698fab3299f68acf0f58781c248 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 3 Mar 2022 20:23:32 -0800 Subject: [PATCH] fix 477 deployment report --- FS/FS/Report/FCC_477.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 -- 2.11.0