Details
-
Task
-
Status: Draft (View Workflow)
-
P3
-
Resolution: Unresolved
-
None
-
None
-
Prokopovych - Sprint 117, Prokopovych - Sprint 118, Prokopovych - Sprint 119
-
Prokopovych
-
TAMU
Description
Overview:
Today I started working on reports that require a call number sort. I pulled the call numbers for some items out of folio to see if they were sorting correctly as LC/NLM call numbers. There is an error in the sorting between whole numbers and decimal numbers.
Look at the attached file as an example. The sql that I ran to create the output is listed at the top of the page. The resulting 50 or so lines were taken as an example.
- Rows 24-33 should come before row 8 because QA9 should sort before QA9.# (.# meaning any numeric value, acting as a decimal)
- For the same reason, rows 40-51 should come before row 36 because QA11 should sort before QA11.2
Steps to Reproduce:
- Log into some FOLIO environment as User X
- Click this
Expected Results:
LC/NLM call numbers should sort in LC/NLM shelflist order
Actual Results:
LC class numbers with decimals are sorting before whole numbers with no decimal instead of after.
Additional Information:
URL:
Interested parties: