diff options
author | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
commit | fed12e8214a8a951377961ccbe7a09171b1e38c2 (patch) | |
tree | b3c902ff90c7397d49716844506a81f921ad9fa4 /httemplate/search/unprovisioned_services.html | |
parent | fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6 (diff) |
make customer location columns available in various reports, #940
Diffstat (limited to 'httemplate/search/unprovisioned_services.html')
-rw-r--r-- | httemplate/search/unprovisioned_services.html | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/httemplate/search/unprovisioned_services.html b/httemplate/search/unprovisioned_services.html index f85e4fb19..89d5f2d66 100644 --- a/httemplate/search/unprovisioned_services.html +++ b/httemplate/search/unprovisioned_services.html @@ -74,7 +74,8 @@ my $search = " where cust_pkg.cancel is null and pkg_svc.quantity > 0 and " . " cust_svc.pkgnum = cust_pkg.pkgnum and " . " cust_svc.svcpart = pkg_svc.svcpart) $svcpart_limit"; -my $addl_from = " join pkg_svc using (pkgpart) join cust_main using (custnum) "; +my $addl_from = " join pkg_svc using (pkgpart) ". + FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg'); # this was very painful to derive but it appears correct #select cust_pkg.custnum,cust_pkg.pkgpart,cust_pkg.pkgnum, pkg_svc.svcpart from cust_pkg join |