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

999 999 999 Records found

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • None
    • None
    • Core: Platform

    Description

      The total records count returned is not exact when there are many records in the database.

      zburke summarized the problem:
      “When a table has many rows, queries that match N rows AND include a limit clause asking for < N rows receive an inaccurate value for totalRecords. Given that same query and a limit clause that overlaps the actual totalRecords value (e.g. the actual result set has 123 records and the query asks for records 100-200), we receive the correct value for totalRecords."

      More context in: MODINVSTOR-414

      API call example and result:

      https://${okapiUrl}/inventory/instances?limit=30&query=(title="" or contributors adj "\"name\": \"\"" or identifiers adj "\"value\": \"\"") sortby title
{
  "instances" : [ {
   ...
  } ],
  "totalRecords" : 999999999
}

      TestRail: Results

        Attachments

          Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-414 totalRecords value may be wildly inaccurate for large collections

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. MODINVSTOR-906 Mention that totalRecords may be estimation in RAML json

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. RMB-93 make number of records to get exact count for configurable

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

            Task - A task that needs to be done. RMB-301 query optimizer hint: sort index or full text index

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

            Task - A task that needs to be done. STCON-90 gracefully handle unexpected changes to totalRecords in the middle of paging

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. STSMACOM-259 Instance search result total is wrong when there are 10K+ records in Inventory

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

            Task - A task that needs to be done. CHAL-240 Populate HRIDs with Libris XL IDs for Libris records with FOLIO-populated HRIDs

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CHAL-294 Query request where offset value > totalRecords returns 0 reords even if actual number of records > totalRecords

            • TBD - To be determined
            • In Code Review

            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

            New Feature - New feature requests RMB-578 Inform whether totalRecords is exact or an estimate

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

            Activity

              People

                Unassigned Unassigned
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases