[MODINVSTOR-414] totalRecords value may be wildly inaccurate for large collections - FOLIO Issue Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: TBD
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: None
Labels:
None

Template:
Development Team:
Other dev

Description

When many many (>10k) instance records are present, the totalRecords value in response to some queries may be wildly in accurate. e.g. when 12k rows are present, the query

/inventory/instances?limit=30&offset=60&query=(languages="fre") sortby title

receives the response

...  "totalRecords" : 999999999

when in fact only ~100 records match the query. The true total can be retrieved by changing the query such that its limit and offset values cover the end of record-count, e.g.

/inventory/instances?limit=30&offset=90&query=(languages="fre") sortby title

which receives the response

...  "totalRecords" : 110

CC: abreaux jakub marcjohnson

TestRail: Results

Attachments

Issue Links

relates to

MODINVSTOR-906 Mention that totalRecords may be estimation in RAML json

Closed

MODINVSTOR-321 999 999 999 Records found

Closed

STSMACOM-259 Instance search result total is wrong when there are 10K+ records in Inventory

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Zak_Burke

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 12/Dec/19 4:38 PM

Updated:: 03/Nov/23 2:55 PM

Resolved:: 09/Jan/20 1:29 PM

totalRecords value may be wildly inaccurate for large collections