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

add indexes for call number searching (normalized)

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Development Team:
      Prokopovych

      Description

      We need 2 virtual indexes for call number searching (normalized):

      • cnsNorm (call number + suffix) and pcnsNorm (prefix+callnumber+suffix) with space and punctuation characters stripped

      Proposed schema.json (pseudo) configuration:

      "index": [
              {
                "fieldName": "pcnsNorm",
                "multiFieldNames": "callNumberPrefix,callNumber,callNumberSuffix",
                "caseSensitive": false,
                "stripWSPunc" true, #does not exist
              },
              {
                "fieldName": "cnsNorm",
                "multiFieldNames": "callNumber,callNumberSuffix",
                "caseSensitive": false,
                "stripWSPunc" true, #does not exist
              }]
      

      CQL

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

      pcnsNorm == "xxx" OR cnsNorm=="xxx"

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                jakub Jakub Skoczen
                Tester Assignee:
                Charlotte Whitt Charlotte Whitt
                Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases