In item search to avoid the parent name:
For example,
When we add field {name} or Name in saved search, the result shows: ‘INVENTORY : 10pc_glass_container_set’ as the item record is saved as the sub item:
So in order to display the result with just the item name without hierarchy, (in this case, just ’10pc_glass_container_set’ )
Use the formula,
NVL( REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”) , {name} )