Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Won't Do
-
None
-
None
-
-
Prokopovych
Description
Overview
During testing export instance UUIDs workflow.
The next missing index has been found
WARNING: Doing FT search without index for instance.jsonb->>'source', CQL >>> SQL: source = folio >>> to_tsvector('simple', f_unaccent(instance.jsonb->>'source')) @@ replace((to_tsquery('simple', f_unaccent('''folio''')))::text, '&', '<->')::tsquery
Steps for testing:
1. Open Inventory App
2. Select Instance tab in top left
3. Select Query search in the drop down and type "source=FOLIO" in search field
4. Under Actions menu click the option “Save instances UUIDs”
Acceptance Criteria
- the indexes are added
- the search consumes less time
- the warnings are disappeared
Additional Information:
URL: https://wiki.folio.org/display/FOLIJET/Export+Instance+UUIDs+Test+Report
TestRail: Results
Attachments
Issue Links
- is cloned by
-
MODINVSTOR-515
Holdings source index for filtering
-
- Closed
-
- is required by
-
UIIN-1132
Filter Instance records by Source
-
- Closed
-
- relates to
-
PERF-28
Exporting UUIDs from Inventory search
-
- Closed
-
-
FOLIO-2573 Paused due to POC of Elastic Search. All Search Options Should be Supported by a Database Index
-
- Closed
-
-
MODINVSTOR-510 Inventory filtering by Item status is slow (when searching item status: Available)
-
- Closed
-