ERROR: Bad Request - placing a request with folio LMS

Description

The error "[400 Bad Request] during [GET] to [http://item-storage/items?query=barcode%3D%3DIMWS000330938/%20and%20id%3D%3Dcadbb4f7-ba8b-5b24-9b81-3a366a5732f8] [InventoryItemStorageClient#fetchItemByQuery(String)]: [org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '/': barcode==IMWS000330938/ and id==cadbb4f7-ba8b-5b24-9b81-3a366a5732f8]" when placing a request with MISSOURI_WESTERN_STATE_UNIV.

Example request: https://libraries-dcb-hub-admin-scaffold-uat-git-production-knowint.vercel.app/patronRequests/b34f68e8-a608-4db6-a9b3-36f6eec4e2f9#auditlog

Attached are the requests currently in this state generated by barcodeEndsWithSlash.sql

 

Attachments

1

Activity

Show:

Tim Auger September 19, 2024 at 8:33 PM

I know we’ve discussed this in the past but “/” are legitimate characters in codabar and code 39 barcode patterns, these are the two most popular barcode formats for libraries.

Chas Woodfield August 28, 2024 at 3:56 PM

If it dosn’t we need to put a block at the preflight stage and change rtac to say they are not available

Marc Johnson August 28, 2024 at 2:11 PM
Edited

This is likely caused by the forward slash (/) in the item barcode

Is this to be expected within MOBIUS?

Does OpenRS need to support special characters like this in item barcodes?

Details

Assignee

Reporter

Components

Priority

Created August 23, 2024 at 3:27 PM
Updated March 25, 2025 at 10:56 PM