[Koha-bugs] [Bug 5904] ysearch.pl members improvements (Independant branches behaviour)
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Apr 7 16:33:28 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5904
claire.hernandez at biblibre.com <claire.hernandez at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |claire.hernandez at biblibre.c
| |om
Patch Status|Needs Signoff |Failed QA
--- Comment #3 from MJ Ray (software.coop) <mjr at 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.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 claire.hernandez at biblibre.com <claire.hernandez at 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.
More information about the Koha-bugs
mailing list