[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