From 27a3aa6e76b70b75d218bbcba997ced8bdbd64e3 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 22 Oct 2009 08:08:59 +0000
Subject: [PATCH] should at least run under pg 8.3 now, need to test & see if
 the data make sense, RT#5496

---
 httemplate/search/svc_phone.cgi | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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,
-- 
2.11.0