From: ivan <ivan>
Date: Thu, 22 Oct 2009 08:08:59 +0000 (+0000)
Subject: should at least run under pg 8.3 now, need to test & see if the data make sense,... 
X-Git-Tag: root_of_svc_elec_features~756
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=27a3aa6e76b70b75d218bbcba997ced8bdbd64e3

should at least run under pg 8.3 now, need to test & see if the data make sense, RT#5496
---

diff --git a/httemplate/search/svc_phone.cgi b/httemplate/search/svc_phone.cgi
index 21e1a9233..0ad458b72 100644
--- a/httemplate/search/svc_phone.cgi
+++ b/httemplate/search/svc_phone.cgi
@@ -102,7 +102,7 @@ if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
 
       my $f_w =
         " FROM cdr_termination LEFT JOIN cdr USING ( acctid ) ".
-        " WHERE cdr.acctid = svc_phone.phonenum ". # XXX connectone-specific
+        " WHERE cdr.carrierid = CAST(svc_phone.phonenum AS BIGINT) ". # XXX connectone-specific, has to match svc_external.id :/
         $and_date;
 
       push @select,