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
LC/NLM call numbers should sort in LC/NLM shelflist order
LC class numbers with decimals are sorting before whole numbers with no decimal instead of after.