diff options
| author | Mark Wells <mark@freeside.biz> | 2015-02-18 15:24:21 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2015-02-18 15:24:21 -0800 |
| commit | 047df8064e648fc81636e08bae8b1cd9065ee793 (patch) | |
| tree | 08708ad7702f8368db3eb786b76fec9de8635a61 /FS | |
| parent | 3d264f58c4f538d4d62fbc8eaa252dc6c5082757 (diff) | |
use media type codes in broadband subscription report, #28020
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Report/FCC_477.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index 6ab9e3489..e8f27f84c 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -400,7 +400,8 @@ sub fbs_sql { my @select = ( "$censustract AS censustract", - 'technology', + '(technology - technology % 10) AS media_type', + # media types are multiples of 10 'broadband_downstream', 'broadband_upstream', "SUM($q)", |