A Database Function to Return ISBN13

Bug #1564402 reported by Jason Stephenson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Invalid
Wishlist
Unassigned

Bug Description

As mentioned in IRC yesterday (http://irc.evergreen-ils.org/evergreen/2016-03-30#i_239409), I have a use case for a database function to return the ISBN13 from its input in the database.

My use case involves dumping data for Novelist's On The Shelf product where they specifically ask for the unique combination of ISBN13 and copy barcode. Pulling the ISBN13 in the database allows one to distinct on the field and to skip records where the data in the ISBN is invalid or cannot be converted to ISBN13.

A branch to create the evergreen.isbn13(text) function will be forthcoming.

description: updated
Revision history for this message
Jason Stephenson (jstephenson) wrote :

Branch in working: user/dyrcona/lp1564402-evergreen-isbn13-function

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp1564402-evergreen-isbn13-function

Complete with release notes and pgtap tests.

tags: added: pullrequest
Revision history for this message
Jason Stephenson (jstephenson) wrote :

Setting this bug to invalid and removing the pull request tag.

I forgot about public.force_to_isbn13 that already does what my "new" function does.

Changed in evergreen:
status: New → Invalid
tags: removed: pullrequest
Changed in evergreen:
milestone: 2.next → none
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.