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

Requests -Filtering by Request Type returns (Total Records = 1000) when there are more

    XMLWordPrintable

Details

    • CP: sprint 92
    • Core: Platform

    Description

      This issue can be observed in Fameflower Bugfest environment and Goldenrod Bugfest

      Filtering of Requests by any Request Type shows Total Records found = 1000 although there are more when querying the db directly

      URL to bugest where this is observed:
      https://bugfest.folio.ebsco.com/requests?filters=requestType.Page&sort=Request%20date

      API Call
      https://okapi-bugfest.folio.ebsco.com/circulation/requests?limit=100&query=%28requestType%3D%22Page%22%29%20sortby%20requestDate

      Response shows – "totalRecords" : 1000

      Direct DB Query shows that there are more than 1000 records for each of the request types

      For example:
      select count(*) from fs09000000_mod_circulation_storage.request where jsonb->>'requestType'='Hold'

      These are the counts observed from the db
      Page = 3457
      Hold=10,656
      Recall =12,395

      TestRail: Results

        Attachments

          Issue Links

            is blocked by

            Bug - A problem which impairs or prevents the functions of the product. CIRCSTORE-219 Create request.requestType b-tree index

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CIRCSTORE-220 Upgrade to raml-module-builder (RMB) 30.2.4

            • TBD - To be determined
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-468 hitcount related issues in Q1

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. UIIN-1070 Paused due to POC of Elastic Search. BugFest: Inventory. Search for Term and Filter by Status = Available Always Results in 1,000 Results

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. UIIN-1129 SPIKE: JTST Environment. Inventory. Search for Status = Available, Sort by Contributor Gives No Results in Main Pane Despite Result Count of 93,717

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases