Remove the Parent Name on Matrix Subitem in an Item Saved Search name

User is unable to remove the parent of a matrix item in an Item Saved Search.

Solution:

Navigate to Lists > Searches > Saved Searches > New

Select Item

Click on Results

Field:

Select Formula (Text)

Formula: Enter CASE NVL2(REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”),1,2) WHEN 2 THEN {name} ELSE REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”) END

Note: This is currently logged under Enhancement #80810. To search and vote for the Enhancement see 10054 Voting for Enhancements.