Uploaded image for project: 'mod-circulation-storage'
  1. mod-circulation-storage
  2. CIRCSTORE-138

Filtering Requests by Request Status doesn't return any rows

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • 9.1.0
    • Core: F - Sprint 68
    • Prokopovych

    Description

      Tested in folio-snapshot (mod-circulation-16.4.0-SNAPSHOT.337) and folio-testing (mod-circulation-16.4.0-SNAPSHOT.338) and the behavior is the same.

      /circulation/requests returns 2 records, both with status "Open - Not yet filled":

      GET /circulation/requests
      x-okapi-tenant: diku
      x-okapi-token: eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJkaWt1X2FkbWluIiwidXNlcl9pZCI6ImQyMTg1OWViLTQ2NzItNWRhMi1iMjhlLTY4NzY1ZGM4NmQzYiIsImNhY2hlX2tleSI6IjFiNDQwY2Y5LTI2OTEtNDIxMS1hMGYyLWY3Mjk0YTFiZDkyZiIsImlhdCI6MTU2MzgxNzgxMywidGVuYW50IjoiZGlrdSJ9.GKjdHabpV-3iM9qwrLWEwSUetzDgw41bpNntSQD8j38
      User-Agent: PostmanRuntime/7.15.0
      Accept: */*
      Cache-Control: no-cache
      Postman-Token: 35cb8786-d08c-4f7a-a69a-6e8a484d3067
      Host: folio-testing-okapi.aws.indexdata.com:443
      accept-encoding: gzip, deflate
      Connection: keep-alive
      HTTP/1.1 200
      status: 200
      Date: Mon, 22 Jul 2019 18:43:16 GMT
      Content-Type: application/json; charset=utf-8
      Transfer-Encoding: chunked
      Connection: keep-alive
      X-Okapi-Trace: GET mod-authtoken-2.3.0-SNAPSHOT.51 http://10.36.1.123:9132/circulation/requests : 202 42418us
      X-Okapi-Trace: GET mod-circulation-16.4.0-SNAPSHOT.338 http://10.36.1.123:9150/circulation/requests : 200 327544us
      { "requests" : [ { "id" : "a36e0c55-9964-424b-9d35-f6e350aee8a2", "requestType" : "Page", "requestDate" : "2019-07-22T17:15:33.000+0000", "requesterId" : "5e3d70ff-a89a-44a0-a2e2-4cae67668805", "itemId" : "22a6203c-d266-4120-bac4-cd6d4b8bcc94", "status" : "Open - Not yet filled", "position" : 1, "item" : { "title" : "Nod", "barcode" : "556677", "holdingsRecordId" : "68872d8a-bf16-420b-829f-206da38f6c10", "instanceId" : "6506b79b-7702-48b2-9774-a1c538fdd34e", "location" : { "name" : "Main Library", "libraryName" : "Datalogisk Institut", "code" : "KU/CC/DI/M" }, "contributorNames" : [ { "name" : "Barnes, Adrian" } ], "status" : "Paged", "callNumber" : "some-callnumber", "copyNumbers" : [ null ] }, "requester" : { "lastName" : "Kautzer", "firstName" : "Evalyn", "middleName" : "Maxine", "barcode" : "356270679006161", "patronGroup" : { "id" : "503a81cd-6c26-400f-b620-14c08943697c", "group" : "faculty", "desc" : "Faculty Member" }, "patronGroupId" : "503a81cd-6c26-400f-b620-14c08943697c" }, "fulfilmentPreference" : "Hold Shelf", "pickupServicePointId" : "3a40852d-49fd-4df2-a1f9-6e2641a6e91f", "metadata" : { "createdDate" : "2019-07-22T17:15:35.437+0000", "createdByUserId" : "d21859eb-4672-5da2-b28e-68765dc86d3b", "updatedDate" : "2019-07-22T17:19:38.295+0000", "updatedByUserId" : "d21859eb-4672-5da2-b28e-68765dc86d3b" }, "pickupServicePoint" : { "name" : "Circ Desk 1", "code" : "cd1", "discoveryDisplayName" : "Circulation Desk -- Hallway", "description" : null, "shelvingLagTime" : null, "pickupLocation" : true } }, { "id" : "c6f319ff-6d01-4ab2-8f75-d5f96385a76d", "requestType" : "Hold", "requestDate" : "2019-07-22T17:16:17.000+0000", "requesterId" : "a98abce3-be00-4d9a-a66a-0593d27b41e0", "itemId" : "22a6203c-d266-4120-bac4-cd6d4b8bcc94", "status" : "Open - Not yet filled", "position" : 2, "item" : { "title" : "Nod", "barcode" : "556677", "holdingsRecordId" : "68872d8a-bf16-420b-829f-206da38f6c10", "instanceId" : "6506b79b-7702-48b2-9774-a1c538fdd34e", "location" : { "name" : "Main Library", "libraryName" : "Datalogisk Institut", "code" : "KU/CC/DI/M" }, "contributorNames" : [ { "name" : "Barnes, Adrian" } ], "status" : "Paged", "callNumber" : "some-callnumber", "copyNumbers" : [ null ] }, "requester" : { "lastName" : "Kovacek", "firstName" : "Meredith", "barcode" : "267941186130073", "patronGroup" : { "id" : "ad0bc554-d5bc-463c-85d1-5562127ae91b", "group" : "graduate", "desc" : "Graduate Student" }, "patronGroupId" : "ad0bc554-d5bc-463c-85d1-5562127ae91b" }, "fulfilmentPreference" : "Hold Shelf", "pickupServicePointId" : "3a40852d-49fd-4df2-a1f9-6e2641a6e91f", "metadata" : { "createdDate" : "2019-07-22T17:16:18.394+0000", "createdByUserId" : "d21859eb-4672-5da2-b28e-68765dc86d3b", "updatedDate" : "2019-07-22T17:24:53.745+0000", "updatedByUserId" : "d21859eb-4672-5da2-b28e-68765dc86d3b" }, "pickupServicePoint" : { "name" : "Circ Desk 1", "code" : "cd1", "discoveryDisplayName" : "Circulation Desk -- Hallway", "description" : null, "shelvingLagTime" : null, "pickupLocation" : true } } ], "totalRecords" : 2
      

      /circulation/requests?query=(status="Open - Not yet filled") returns 0 records:

      GET /circulation/requests?query=%28status=%22Open%20-%20Not%20yet%20filled%22%29
      x-okapi-tenant: diku
      x-okapi-token: eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJkaWt1X2FkbWluIiwidXNlcl9pZCI6ImQyMTg1OWViLTQ2NzItNWRhMi1iMjhlLTY4NzY1ZGM4NmQzYiIsImNhY2hlX2tleSI6IjFiNDQwY2Y5LTI2OTEtNDIxMS1hMGYyLWY3Mjk0YTFiZDkyZiIsImlhdCI6MTU2MzgxNzgxMywidGVuYW50IjoiZGlrdSJ9.GKjdHabpV-3iM9qwrLWEwSUetzDgw41bpNntSQD8j38
      User-Agent: PostmanRuntime/7.15.0
      Accept: */*
      Cache-Control: no-cache
      Postman-Token: 59a49e64-1d66-4ecf-a48a-f4c06fa776eb
      Host: folio-testing-okapi.aws.indexdata.com:443
      accept-encoding: gzip, deflate
      Connection: keep-alive
      HTTP/1.1 200
      status: 200
      Date: Mon, 22 Jul 2019 18:48:58 GMT
      Content-Type: application/json; charset=utf-8
      Transfer-Encoding: chunked
      Connection: keep-alive
      X-Okapi-Trace: GET mod-authtoken-2.3.0-SNAPSHOT.51 http://10.36.1.123:9132/circulation/requests.. : 202 34740us
      X-Okapi-Trace: GET mod-circulation-16.4.0-SNAPSHOT.338 http://10.36.1.123:9150/circulation/requests.. : 200 17754us
      { "requests" : [ ], "totalRecords" : 0 }
      

      Once "query=" is removed the records are displayed correctly. This breaks filtering by Request Status in Requests apps (UIREQ-296)

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                wwelling William Welling
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases