Uploaded image for project: 'ui-requests'
  1. ui-requests
  2. UIREQ-639

Use == not = for item barcode search

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 123
    • Story Points:
      1
    • Development Team:
      Core: Platform

      Description

      Searching for an item barcode takes minutes in a large DB when using the full text match operator =.

      mod-inventory-storage no longer has a database index for this full text item barcode search (MODINVSTOR-523).

      Use the exact match operator == instead, it also allows right truncation when appending a star.

      There are no use cases where the search term 123456 should find barcode 98765-123456, all other item barcode searches have already switched to ==.

      Learn about CQL string matching at https://dev.folio.org/faqs/explain-cql/

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                julianladisch Julian Ladisch
                Reporter:
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases