From c48c387bf982b95dbd2f0e26e5f4fa967884af35 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 22 Dec 2016 17:23:08 -0800 Subject: [PATCH] fix "column refnum is ambiguous" error pulling up churn detail when you have a single advertising source, RT#73852 --- FS/FS/cust_pkg.pm | 4 ++-- 1 file 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; } ### -- 2.11.0