Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
None
-
None
-
-
3
-
Prokopovych
Description
Steps to reproduce:
- Login to FOLIO BugFest,
- Clear cache for page by clicking ctrl F5 in Windows or Command + Shift + R on a Mac
- Go to Inventory
- Select the Instance segment in the Search and filter pane
- Search in the search box on Keyword (title, contributor, identifier) on: Jensen (I saw this problem when doing other searches, as well (e.g. Contributor)
- Notice that the results are sorted by Title by default (despite
- "2,508 records found" is displayed
- Switch to the Holdings segment and select "Keyword (title, contributor, identifier), and search on: Jensen
- Notice that the results are NOT sorted by Title by default
- "7,955 records found" is displayed
- Switch to the Item segment and select "Keyword (title, contributor, identifier), and search on: Jensen
- Notice that the results are NOT sorted by Title by default
- "7,955 records found" is displayed
- Switch then back again Instance segment, click "reset all" and select "Keyword (title, contributor, identifier), and search on: Jensen
- Results are no longer sorted by Title by default (the only way I can get this default sort to happen again is to clear the cache)
- "7,955 records found" is displayed
- Now, click the Title column header to manually sort by Title
- Notice that the result count changes to "2,508 records found"
- Now click "Reset all" and switch to Contributor search
- Search for Jensen
- Notice that, also when searching contributors by Jensen, sorting by Title gives different result counts (presumably this happens for many types of searches)
Expected Result:
- Sorting by Title (or any other column) should not change the result count
Actual Result:
- When sorted by title (either by default the first time after cache cleared or manually by clicking the column header), the result count that displays changes (in some cases considerably)
- Screencast: https://drive.google.com/file/d/18qLEG5Tic1vvCIgccSq3DRKwUmtWDhvE/view?usp=sharing
Additional Info:
- Sorting by other columns doesn't change the results count
- We have another issue wherein sorting by title gives different result counts when applying filters:
UIIN-1071 - Testing this in BugFest resulted in instability and crashes over time:
Screenshots:
Search on Instance segment, Keyword (title, contributor, identifier): Jensen => 2,508 records found
Search on Holdings segment, Keyword (title, contributor, identifier): Jensen => 7,631 records found
Search on Item segment, Keyword (title, contributor, identifier): Jensen => 7,631records found
Search on Instance segment, Keyword (title, contributor, identifier): Jensen => 7,631 records found
TestRail: Results
Attachments
Issue Links
- is blocked by
-
MODINVSTOR-468 hitcount related issues in Q1
-
- Closed
-
-
MODINVSTOR-519 Upgrade RMB to 30.0.3, fixing inconsistent hit counts (totalRecords) estimation
-
- Closed
-
-
RMB-591 remove or harmonize 'optimizedSql' execution path
-
- Closed
-
- relates to
-
UIIN-1049 Paused due to POC of Elastic Search. Bugfest: Inventory. Effective Location Result Counts Don't Add Up (Off by Unacceptable Amount) And Seem Suspicious
-
- Closed
-
-
UIIN-1050 Paused due to POC of Elastic Search. SPIKE: Bugfest: Inventory. Item segment. Filtering on Suppress from discovery: Yes and No Don't Add Up (Off by Unacceptable Amount)
-
- Closed
-
-
UIIN-1130 JTST Environment: Sorting by Contributors or Publisher Columns Give Different Result Counts Than Sort by Title or No Sort
-
- Closed
-
-
CHAL-294 Query request where offset value > totalRecords returns 0 reords even if actual number of records > totalRecords
-
- In Code Review
-
- requires
-
RMB-591 remove or harmonize 'optimizedSql' execution path
-
- Closed
-