ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
61 stars 13 forks source link

Bug Report: Find Containers Sort Expansion Options not working #8262

Open campmlc opened 3 weeks ago

campmlc commented 3 weeks ago

Describe the bug In Find Container, the sort expansion option should allow operators to request the results of a container search be sorted by either label:barcode, barcode:label, label:barcode numeric, or barcode:label numeric. But no matter which option I select, I get the same results in the same order, which is reverse order by box position (4, 3, 2), and random order by box barcode or box label. I would like the order to be by label in numeric order, so that the freezer box position orders from smallest to largest: 2, 3, 4 in this case. But regardless, the results should change depending on which order profile I select, and they do not.

To Reproduce Steps to reproduce the behavior:

  1. Go to https://arctos.database.museum/findContainer.cfm
  2. Enter in Label value: %2024.045.Mamm% to find the box label with the accession number
  3. See error of box positions ordered from high to low
  4. Change the Sort Expansion options to different values and redo search
  5. See that nothing changes no matter what selection is entered for the Sort value

Screenshots

Screenshot 2024-11-04 10 04 45

Data If this involves external data, attach the actual data that caused the problem. Do not attach a transformation or subset. You may ZIP most formats to attach, or request a Box email address for very large files.

Desktop (please complete the following information):

Additional context Add any other context about the problem here.

campmlc commented 3 weeks ago

@falco-rk @happiah-madson @megulbranson