From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 23 Dec 2016 01:22:21 +0000 (-0800)
Subject: fix "column refnum is ambiguous" error pulling up churn detail when you have a single... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=c3b6a3e02cbe18b67714f11d502492e234d7ac77

fix "column refnum is ambiguous" error pulling up churn detail when you have a single advertising source, RT#73852
---

diff --git a/FS/FS/cust_pkg/Search.pm b/FS/FS/cust_pkg/Search.pm
index 3a8e6d01e..311dbdbe1 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;
   }
 
   ###