http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5904
[email protected] <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |om Patch Status|Needs Signoff |Failed QA --- Comment #3 from MJ Ray (software.coop) <[email protected]> 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.html Bug 5904 - Follow up patch, with the db changes http://lists.koha-community.org/pipermail/koha-patches/2011-March/014144.html --- Comment #4 from [email protected] <[email protected]> 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
