Saved Search formula to avoid Item Hierarchy

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} )

Leave a comment

Your email address will not be published. Required fields are marked *