diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:23:08 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:23:08 -0800 |
| commit | c48c387bf982b95dbd2f0e26e5f4fa967884af35 (patch) | |
| tree | 66a3319454a7431fdae8360f9a7b9092aaa1172d | |
| parent | 3bde0c43f02bf817cce2458a1a49312b1aef1de7 (diff) | |
fix "column refnum is ambiguous" error pulling up churn detail when you have a single advertising source, RT#73852
| -rw-r--r-- | FS/FS/cust_pkg.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm index c1039b59f..819dadeb6 100644 --- a/FS/FS/cust_pkg.pm +++ b/FS/FS/cust_pkg.pm @@ -5343,7 +5343,7 @@ sub search { } ### - # parse refnum (advertising source) + # parse (customer) refnum (advertising source) ### if ( exists($params->{'refnum'}) ) { @@ -5354,7 +5354,7 @@ sub search { @refnum = ( $params->{'refnum'} ); } my $in = join(',', grep /^\d+$/, @refnum); - push @where, "refnum IN($in)" if length $in; + push @where, "cust_main.refnum IN($in)" if length $in; } ### |