Cannot find Instance by Item call number using asterisk at the beginning of the query
Description
CSP Request Details
CSP Rejection Details
Potential Workaround
Attachments
defines
is cloned by
relates to
Checklist
hideTestRail: Results
Activity
Yauhen Viazau July 27, 2023 at 11:36 AM
As per discussion PO and the rest of the team - such search scenario is not supported and and this is expected. Closing the ticket.
- please provide a list of fields for which this type of truncation is not supported now for POs and QAs to be able to use as a reference

Khalilah Gambrell July 26, 2023 at 1:37 PM
Hey - we have FOLIO libraries that want to conduct left truncation searches. More work is planned in this area over the next couple of releases.
cc: and
Pavlo Smahin July 26, 2023 at 9:08 AM
, , this search option doesn't support this type of truncation. Please see the initial requirements in

Julian Ladisch July 25, 2023 at 6:14 PM
Standard indexes support truncation at the end. To support truncation at the beginning more advanced indexes are needed.
Do we really need item call number left truncation search?

Dmytro Melnyshyn July 25, 2023 at 3:08 PM
Hi , looks like BE doesn't support an asterisk at the beginning for "Effective call number (item), normalized". Please take a look at the message above.
Details
Details
Assignee

Overview: Cannot find Instance by Item call number using asterisk at the beginning of the query. Also, cannot find Instance by Item call number using "Contains all" option in Advanced search if query has one or several first characters of call number omitted
Steps to Reproduce:
Login to Snapshot as user with "Inventory: All permissions" permission
Open "Inventory" app
Add Holdings with Item to any existing Instance:
Click "Add holdings" button in Instance detail view
Fill call number field ("YCN123456987")
Fill all required fields
Click "Save & close" button
Click "Add item" button in added Holdings line in Instance detail view
Fill all required fields (do not fill "Call number")
Click "Save & close" button
Add Holdings with Item to another existing Instance:
Click "Add holdings" button in Instance detail view
Fill all required fields (do not fill "Call number")
Click "Save & close" button
Click "Add item" button in added Holdings line in Instance detail view
Fill call number field ("001MYCN2225858881")
Fill all required fields
Click "Save & close" button
Select "Item" toggle in first pane
Select "Effective call number (item), normalized" search option
Fill search input field with "*01MYCN2225858881" → Click "Search"
Fill search input field with "*CN123456987" → Click "Search"
Select "Holdings" toggle in first pane
Select "Call number, normalized" search option
Fill search input field with "*CN123456987" → Click "Search"
Expected Results:
Step 7 - Instance from Step 4 is shown in second pane
Step 8 - Instance from Step 3 is shown in second pane
Step 11 - Instance from Step 4 is shown in second pane
Actual Results: No results found at Steps 7, 8, 11
Additional Information:
See attached screencasts:
Interested parties: