Uploaded image for project: 'ui-inventory'
  1. ui-inventory
  2. UIIN-1517

Item effectiveShelvingOrder doesn't sort LC call numbers correctly

    XMLWordPrintable

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:
      1. Log into some FOLIO environment as User X
      2. 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:

      TestRail: Results

        Attachments

          Activity

            People

              Unassigned Unassigned
              hismith Anne L. Highsmith
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                TestRail: Runs

                  TestRail: Cases