diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:22:22 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:22:22 -0800 |
| commit | 734745daedd3efc6728ebfdb48eac1af71960a06 (patch) | |
| tree | d92249e45960c3f4ec697fdbc7a0aee9948e648e /FS/FS/cust_pkg | |
| parent | 8809044f78f3ea5d33d0d449a8f7070d52b54b07 (diff) | |
fix "column refnum is ambiguous" error pulling up churn detail when you have a single advertising source, RT#73852
Diffstat (limited to 'FS/FS/cust_pkg')
| -rw-r--r-- | FS/FS/cust_pkg/Search.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/cust_pkg/Search.pm b/FS/FS/cust_pkg/Search.pm index 3a8e6d0..311dbdb 100644 --- a/FS/FS/cust_pkg/Search.pm +++ b/FS/FS/cust_pkg/Search.pm @@ -281,7 +281,7 @@ sub search { } ### - # parse refnum (advertising source) + # parse (customer) refnum (advertising source) ### if ( exists($params->{'refnum'}) ) { @@ -292,7 +292,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; } ### |