From 54874515da35cc39db56c647b992ae8dea17ad21 Mon Sep 17 00:00:00 2001 From: Jonathan Prykop Date: Thu, 25 Feb 2016 12:56:28 -0600 Subject: [PATCH] RT#38597: OQM - svc Circuit use and setup [fixed case handling] --- FS/FS/svc_circuit.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/FS/FS/svc_circuit.pm b/FS/FS/svc_circuit.pm index 1a42efadd..13d84846e 100644 --- a/FS/FS/svc_circuit.pm +++ b/FS/FS/svc_circuit.pm @@ -221,9 +221,9 @@ sub label { sub search_sql { my ($class, $string) = @_; my @where = (); - push @where, 'LOWER(svc_circuit.circuit_id) = ' . dbh->quote($string); - push @where, 'LOWER(circuit_provider.provider) = ' . dbh->quote($string); - push @where, 'LOWER(circuit_type.typename) = ' . dbh->quote($string); + push @where, 'LOWER(svc_circuit.circuit_id) = LOWER(' . dbh->quote($string) . ')'; + push @where, 'LOWER(circuit_provider.provider) = LOWER(' . dbh->quote($string) . ')'; + push @where, 'LOWER(circuit_type.typename) = LOWER(' . dbh->quote($string) . ')'; '(' . join(' OR ', @where) . ')'; } -- 2.11.0