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

array queries with additional clauses may fail

    XMLWordPrintable

Details

    • CP: sprint 68, CP: sprint 69
    • 3
    • 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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases