Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-444

add indexes for call number searching (eye readable)

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 19.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      Core: F - Sprint 82, Core: F - Sprint 83
    • Story Points:
      3
    • Development Team:
      Prokopovych

      Description

      We need 2 virtual indexes for call number searching on the "holdings" table and 2 on the "items" table. Example below only covers "holdings", "items" is similar.

      • * callNumberAndSuffix* (call number + suffix) and * fullCallNumber* (prefix+callnumber+suffix) with lower-case and space normalization applied

      Proposed schema.json (pseudo) configuration:

      "index": [
              {
                "fieldName": "fullCallNumber",
                "multiFieldNames": "callNumberPrefix,callNumber,callNumberSuffix",
                "caseSensitive": false,
                "normalizeWS" true, #does not exist [~charlotte] says this normalization can be skipped for Q1
              },
              {
                "fieldName": "callNumberAndSuffix",
                "multiFieldNames": "callNumber,callNumberSuffix",
                "caseSensitive": false,
                "normalizeWS" true, #does not exist [~charlotte] says this normalization can be skipped for Q1
              }]
      

      CQL

      The following CQL should be used for the client/UI search:

      fullCallNumber == "xxx" OR callNumberAndSuffix=="xxx"

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                bohdan-suprun Bohdan Suprun
                Reporter:
                jakub Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases