Saturday, September 8, 2018

Display item name without showing hierarchical information

A common question from customers is how to display the child item name only 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.

1. Navigate to Lists > Search > Saved Searches > New > Item.
2. Enter the criteria needed to limit the results.
3. Click on the Results tab.
4. Select Formula (Text) under the Field column.
5. Set the Formula field to:
LTRIM(regexp_substr({itemid},'[^:]*$'))
6. Click Save & Run.

For 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.

No comments:

Post a Comment