Search for titles with value with parenthesis results in error messages when search term: All (title, contributor, identifier)
Description
CSP Request Details
CSP Rejection Details
Potential Workaround
Attachments
- 27 May 2019, 09:05 AM
- 27 May 2019, 09:05 AM
- 27 May 2019, 09:05 AM
- 27 May 2019, 09:05 AM
- 27 May 2019, 09:05 AM
- 27 May 2019, 09:05 AM
- 27 May 2019, 08:12 AM
- 20 May 2019, 11:29 AM
- 20 May 2019, 11:25 AM
defines
is blocked by
relates to
Checklist
hideTestRail: Results
Activity
Cate Boerema July 9, 2019 at 8:28 AM
Yes this passes test. Thanks @Jakub Skoczen!!
Jakub Skoczen July 8, 2019 at 6:09 PM
@Cate Boerema I think this one is fixed – closing, please re-open if I made a mistake.
Cate Boerema June 11, 2019 at 3:41 PM
per @Julian Ladisch's above comment, this seems to be a Core Platform issue. Reassigning.
FYI @Jakub Skoczen
Julian Ladisch June 7, 2019 at 7:15 AM
I agree, the only front-end issue is https://folio-org.atlassian.net/browse/UIIN-589 "Mask double quotes and backslash"
Zak Burke June 4, 2019 at 7:46 PM
Do we think this is a front-end/UIIN bug and the front-end should be encoding the query string differently here, or is this really a back-end RMB/CIRC ticket related to string interpolation and this ticket is just the user-visible symptom of a back-end problem?
The only real front-end problem I see here is that entering a search term with quotes, e.g.
foo"clearly generates an invalid query string, e.g.
(title="foo"") sortby titleso that value needs to be encoded or escaped before it's substituted into the query string.
Details
Details
Assignee
Reporter
Priority
P2
Preconditions:
I created following titles (for test purpose): Inventory instance record in FOLIO Snapshot to have resource title: Arctic A to Z (2019), and resource title: (accidental atheist)
Steps to reproduce:
Login to FOLIO Snapshot go to Inventory:
search for:
Arctic A to Z (2019)in search term: All (title, contributor, identifier)search for:
Arctic A to Z (2019)in search term: Titlesearch for:
(accidental atheist)in search term: All (title, contributor, identifier)search for:
(accidental atheist)in search term: TitleExpected result:
Each of the performed search would bring up 1 hit
Actual result:
Search on titles with parenthesis works fine in search term Title, but fails in search term: All (title, contributor, identifier)
ERROR: in module @folio/inventory, operation GET on resource 'records' failed, saying: ErrorMessage(fields=Map(Line -> 208, File -> regexp.c, SQLSTATE -> 2201B, Routine -> RE_compile_and_cache, V -> ERROR, Message -> invalid regular expression: parentheses () not balanced, Severity -> ERROR))- - - - - - - - - - - - - - - - - -
Since FOLIO requires that I enter an exact match, but the exact value in this case produces an error, I see no way of actually finding this instance by ISBN.
Having parenthesis in ISBN fields is not at all uncommon. The same goes for subject headings.
CW: @Lisa Sjögren - when you search on ISBN numbers you'd like to have an exact match on the digits in the ISBN, and then the possibility to truncate. When you perform following search: 978-0-226-23584-4* in the Identifier/ISBN field, you get 1 hit: