Scenario
User wants to display only the child item name in search results. Since there is no field or setting that excludes the hierarchical information, users will have to use a formula to achieve this. This Formula (Text) works when used in ‘search results’.
Solution
To create the saved search, follow the steps below:
Navigate to Lists > Search > Saved Searches > New
Select Item
Search Title: Enter preferred title
Click Criteria tab
Note: Enter the criteria needed to limit the results
Click on the Results tab
Add the following fields:
Select Formula (Text)
Formula: Enter ltrim(regexp_substr({name},'[^:]*$’))
Click Save & Run
Example: Without the formula, the results will show: ‘Angie Matrix : Angie Matrix-1000g-R-Red’. Using the above formula, the search results will display: ‘Angie Matrix-1000g-R-Red’ only.