[Patches] [PATCH] Bug 7053: patron name search

koha-patchbot at kohaaloha.com koha-patchbot at kohaaloha.com
Sat Nov 26 03:30:03 NZDT 2011


From: Adrien Saurat <adrien.saurat at biblibre.com>
Date: Fri, 25 Nov 2011 14:52:53 +0100
Subject: [PATCH] Bug 7053: patron name search

Allows search on names containing spaces.
Example: "LA JOIE"
Allows search on strings included in name
Example: "james acevedo" to find "henry hames acevedo III"
---
 C4/SQLHelper.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/SQLHelper.pm b/C4/SQLHelper.pm
index a15beb8..a3af4a6 100644
--- a/C4/SQLHelper.pm
+++ b/C4/SQLHelper.pm
@@ -403,7 +403,7 @@ sub _Process_Operands{
 		}
 		if ($searchtype eq "start_with"){
 			push @tmpkeys,("$field LIKE ?","$field LIKE ?");
-			push @localvaluesextended, ("$operand\%", " $operand\%") ;
+			push @localvaluesextended, ("$operand\%", "\% $operand\%") ;
 		}
 		push @values, at localvaluesextended;
 	}
-- 
1.7.4.1




More information about the Patches mailing list