Item - support full text search notes field
Description
Environment
None
Potential Workaround
None
CSP Request Details
None
CSP Rejection Details
None
CSP Approved
None
clones
defines
is cloned by
Checklist
hideTestRail: Results
Activity
Show:

Magda Zacharska July 12, 2021 at 3:40 PM
please provide an example of the search query.
Done
Created April 23, 2021 at 2:31 AM
Updated July 20, 2021 at 8:38 AM
Resolved July 16, 2021 at 2:09 PM
TestRail: Cases
TestRail: Runs
Purpose/Overview:
The purpose of this story is to allow the user a full text search within the item's notes field.
Requirements/Scope:
Case insensitive
Word match in the Inventory item's [Notes[].note (array of strings)|https://github.com/folio-org/mod-inventory-storage/blob/32661579c0eb0f52f0513847c522dd0e548fa77a/ramls/instance.json#L327]
Search by public notes when staff only note is set to false
Search by all item notes
Supports search in other than English languages (including CKJ languages, Arabic, Hebrew)
Acceptance criteria:
Query returns accurate hit count
User can search by any word that is a part of the field's value
Results are ranked based on term frequency, inverse document frequency and field length
Stemming according with configured on the tenant language tokenizers
Assumptions:
Hyphens are treated as separators of the tokens.
Outside the scope:
limiting search by the note type
Additional Information:
Inventory item schema: https://github.com/folio-org/mod-inventory-storage/blob/master/ramls/item.json