Scenario: Client needs to create search to show the locations for which the checkbox are checked within a single column.
Solution:
List> Search> Saved Searches
Select: Item
Enter Search Title
Criteria:
Type: Inventory Item
Select Transactions
Enter Search Title
Criteria:
Type: Sales Order
Main line: False
Tax line: False
COGS: False
Shipping: False
Results:
Field: Name
Field: Formula(Text),
CASE WHEN {custitem_jj_strloc_flrmtx_sanjos_1903} = ‘T’ THEN ‘SAN JOSE’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_concord_1903} = ‘T’ THEN ‘CONCORD’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_emyvle_1903} = ‘T’ THEN ‘EMERYVILLE’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_sanrfl_1903} = ‘T’ THEN ‘SAN RAFAEL’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_rosvil_1903} = ‘T’ THEN ‘ROSEVILLE’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_hywd_1903} = ‘T’ THEN ‘HAYWARD’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_dublin_1903} = ‘T’ THEN ‘DUBLIN’ ELSE NULL END||’ ‘||CASE WHEN {custitem_jj_strloc_flrmtx_rdcity_1903} = ‘T’ THEN ‘ REDWOOD CITY’ ELSE NULL END
Label: Floor Matrix
Click Save