http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5904 claire.hernandez@biblibre.com <claire.hernandez@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |claire.hernandez@biblibre.c | |om Patch Status|Needs Signoff |Failed QA --- Comment #3 from MJ Ray (software.coop) <mjr@ttllp.co.uk> 2011-04-01 09:42:38 UTC --- This bug is mentioned in: Bug 5904 : ysearch.pl members improvements (Independant branches behaviour) http://lists.koha-community.org/pipermail/koha-patches/2011-March/014143.htm... Bug 5904 - Follow up patch, with the db changes http://lists.koha-community.org/pipermail/koha-patches/2011-March/014144.htm... --- Comment #4 from claire.hernandez@biblibre.com <claire.hernandez@biblibre.com> 2011-04-07 14:33:28 UTC --- Produce this query: SELECT surname, firstname, cardnumber, address, city, zipcode, country FROM borrowers WHERE surname LIKE 'a%' OR firstname LIKE 'a%' OR cardnumber LIKE 'a%' AND borrowers.branchcode ='MPL' ORDER BY surname, firstname I think it should produce ... WHERE (surname LIKE 'a%' OR firstname LIKE 'a%' OR cardnumber LIKE 'a%') AND borrowers.branchcode ='MPL' ORDER BY surname, firstname -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.