[Koha-bugs] [Bug 9728] New: XISBN use simple search instead of SQL
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Feb 28 12:35:17 CET 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9728
Bug ID: 9728
Summary: XISBN use simple search instead of SQL
Classification: Unclassified
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Staff Client
Assignee: koha-bugs at lists.koha-community.org
Reporter: fridolyn.somers at biblibre.com
CC: gmcharlt at gmail.com
XISBN API uses normalized ISBN of a biblio to get a list of ISBNs, then
searches via SQL in database for notices with those ISBNs.
I noticed that if input ISBN has hyphens then returned ISBNs have hyphens else
they don't have. So SQL query will not find if ISBNs have hyphens in database.
Also, if biblio has several ISBN, only first one can be found with actual SQL
query (isbn LIKE '$xisbn%').
So I propose to use a simple search "nb=$xisbn". This will find biblio from
ISBN with or without hyphen.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list