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

999 999 999 Records found

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Template:
    • Development Team:
      Core: Platform

      Description

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

      Zak_Burke 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

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases