To exclude the parent item's name on Search results, perform the following:
- Navigate to Reports > Saved Searches > All Saved Searches > New.
- Click Item.
- On Results tab and Columns subtab, add Formula (text) and enter the formula below under Formula column:
- CASE NVL2(REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ',''),1,2) WHEN 2 THEN {name} ELSE REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ','') END
- Click Preview or Save.
No comments:
Post a Comment