Sunday, September 23, 2018

Exclude Parent Item Name on Search Results

To exclude the parent item's name on Search results, perform the following:

  1. Navigate to Reports > Saved Searches > All Saved Searches > New.
  2. Click Item.
  3. 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
  4. Click Preview or Save.

No comments:

Post a Comment