Display only the Parent Item Name on a Transaction Search

1. Create a transaction search
   1.1. Lists > Search > Saved Searches > New > Transactions
   1.2. Criteria > set desired criteria
   1.3. Results:
          i. Add Formula (Text) > Formula
             case when 
             instr(NVL2({item.parent},{item.parent},{item}),':',1) <> 0 then substr(NVL2({item.parent},{item.parent},{item}),1,(instr(NVL2({item.parent},
                    {item.parent},{item}),':',1)) - 1) 
             else
             NVL2({item.parent},{item.parent},{item}) end
   1.4. Add other fields

2. Search Title = label the search

3. Preview or Save & Run