diff options
author | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:22:21 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:22:21 -0800 |
commit | c3b6a3e02cbe18b67714f11d502492e234d7ac77 (patch) | |
tree | 6df2dd150abb85c98bfb07897f0fe8c140f70484 | |
parent | 8689850a78c5ef0c744dc1824f22a61d36ed4365 (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/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; } ### |