Serials Batch Receive - unable to search by ISSN or Database ID

[Christine Burns]

New bug discovered in Evergreen version 2.12

In the Serials Batch Receive interface you are supposed to be able to search for receivable issues using either the Database ID or ISSN.

when attempting to search by Database ID or ISSN I get the following error = "Database Query Failed" followed by "No matching records found with any subscriptions attached"

If you access the Serials batch receive interface from a specific record the interface loads as usual.

Example Search -> Retrieve title by database ID -> Actions for this Record -> Serials Batch Receive -> Next -> this works as expected & receivable issues are listed.

But if you click on "Start Over" you are prompted to "Enter an identifier for a bibliographic record" this is where the search fails

Example enter "109242427" results in the 2 errors attached

Desired behavior - If you enter a database ID or ISSN in the "Enter an identifier for a bibliographic record" field the receivable issuances should be displayed

[Jeff Davis (jdavis-sitka)]

Working branch user/jeffdavis/lp1682296-db-error-serials-batch-receive has a fix for this:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=commitdiff;h=655e45f

The branch is several months old but the commit can be cherry-picked to current master without any trouble.

[Cesar V (cesardv)]

Tested this on a local 2.12 EG instance, XUL client no longer gives DB query error when searching by BRE id in Serial Batch Receive. Thanks Jeff!

Here's a fresher signed off branch:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/cesardv/jeffdavis_lp1682296-db-error-serials-batch-receive

[Galen Charlton (gmc)]

Pushed to master, rel_3_1, and rel_3_0. Thanks, Jeff and Cesar!