X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_main.cgi;fp=httemplate%2Fsearch%2Fcust_main.cgi;h=7bcd5bfcde60c5927683cfbb6665eeba506f9332;hp=ba80f02751dcc8b51f0bead555403cb0349666d5;hb=ef0ddff4fa7109a4c279995d920220f3cc83c976;hpb=989523fb2a31eeb5ee19ed2ef24117da3d2683e5 diff --git a/httemplate/search/cust_main.cgi b/httemplate/search/cust_main.cgi index ba80f0275..7bcd5bfcd 100755 --- a/httemplate/search/cust_main.cgi +++ b/httemplate/search/cust_main.cgi @@ -501,8 +501,13 @@ my $pkgs_method = $conf->exists('hidecancelledpackages') : 'all_pkgs'; #false laziness w/httemplate/view/cust_main/packages.html -my $select = '*, setup_option.optionvalue AS _opt_setup_fee, '. - 'recur_option.optionvalue AS _opt_recur_fee', +my $select = join(',', + 'cust_pkg.*', + 'part_pkg.*', + 'setup_option.optionvalue AS _opt_setup_fee', + 'recur_option.optionvalue AS _opt_recur_fee', + ); + my $addl_from = qq{ LEFT JOIN part_pkg USING ( pkgpart ) LEFT JOIN part_pkg_option AS setup_option