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

array queries with additional clauses may fail

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 68, CP: sprint 69
    • Story Points:
      3
    • Development Team:
      Core: Platform

      Description

      This issue has been also raised during Bugest 3.1 manual testing as UIIN-664 and this ticket is not a blocker for it

      The following query generates a 500 response with no body:

      /instance-storage/instances?query=((contributors =/@name "FOO") and holdingsRecords.permanentLocationId="fcd64ce1-6995-48f0-840e-89ffa2288371") 
      

      but these are all successful:

      /instance-storage/instances?query=(title = "FOO" or contributors =/@name "FOO")
      /instance-storage/instances?query=(contributors =/@name "FOO")
      /instance-storage/instances?query=((title="FOO") and holdingsRecords.permanentLocationId="fcd64ce1-6995-48f0-840e-89ffa2288371") 
      /instance-storage/instances?query=(holdingsRecords.permanentLocationId="fcd64ce1-6995-48f0-840e-89ffa2288371") 
      

      The X-Okapi-Trace header contains:

      GET mod-authtoken-2.3.0-SNAPSHOT.49 http://10.0.2.15:9144/inventory/instances.. : 202 21696us, 
      GET mod-inventory-storage-15.6.0-SNAPSHOT.289 http://10.0.2.15:9147/instance-storage/instances.. : 500 26742us
      

      Steps to repro:

      1. Go to inventory
      2. Search using All, Identifier, ISBN, ISSN, Contributor
      3. Apply location filter

      Expected: Narrows results by location (effective location?)

      Actual: Error shown ERROR: in module @folio/inventory, operation GET on resource 'records' failed, saying: org.folio.cql2pgjson.exception.QueryValidationException: CQL: Unsupported relation modifier @name

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                evaluk Eric Valuk
                Reporter:
                zburke Zak_Burke
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases