Display Main line criteria, Body-level location, and Line-level location in transaction saved search using Formula

Scenario: To display main line criteria, body-level location, and line-level location in the transaction search result, we may use the following formulas

Mainline condition formula :

Formula(text) – Case When {mainline}=’*’ then ‘True’ else ‘False’ end

Body level location:

Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘True’ THEN {location} end

Line level location:

Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘False’ THEN {location} end