diff options
| author | Jonathan Prykop <jonathan@freeside.biz> | 2015-09-19 20:32:00 -0500 |
|---|---|---|
| committer | Jonathan Prykop <jonathan@freeside.biz> | 2015-09-29 01:09:43 -0500 |
| commit | 61e8e75f45382cfa5ad6a52be58c9744dee8cba8 (patch) | |
| tree | c70583619c774c67ca6a6f36b89f29b90c810242 | |
| parent | ef9491e6007b7aed7ae0e0486a6abb237ca08519 (diff) | |
RT#37488: Tower/sector selection box is showing disabled towers [removed disabled when using tower_sector]
| -rw-r--r-- | httemplate/elements/select-tower_sector.html | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/httemplate/elements/select-tower_sector.html b/httemplate/elements/select-tower_sector.html index 458bcddcf..76ff25223 100644 --- a/httemplate/elements/select-tower_sector.html +++ b/httemplate/elements/select-tower_sector.html @@ -2,6 +2,8 @@ <& /elements/select-table.html, table => 'tower_sector', name_col => 'description', + addl_from => 'JOIN tower USING (towernum)', + extra_sql => q(WHERE disabled = '' OR disabled IS NULL), order_by => 'ORDER BY towernum,sectorname', empty_label => ' ', @_ |