From 3907da4465b5ca211f9af7556f811eff252fcd23 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 2 Jun 2011 21:52:57 +0000
Subject: fix svc_port searches

---
 httemplate/search/cust_svc.html | 1 +
 1 file changed, 1 insertion(+)

(limited to 'httemplate')

diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html
index 72ecb8e35..9cf4bbda6 100644
--- a/httemplate/search/cust_svc.html
+++ b/httemplate/search/cust_svc.html
@@ -75,6 +75,7 @@ if ( length( $cgi->param('search_svc') ) ) {
 
   $cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb";
   push @extra_sql, "svcdb = '$1'";
+  $addl_from .= " LEFT JOIN $1 USING ( svcnum ) ";
 
   push @extra_sql, 'pkgnum IS NULL'
     if $cgi->param('magic') eq 'unlinked';
-- 
cgit v1.2.1