Formatted Search

Hello experts,

I have 2 user-defined fields Purchasing Category and Purchasing Sub-category

I want to build a FMS on Purchasing category and Purchasing Sub-category.

Please look at the screenshots attached.

item-master-data.png

purchasing-category-list.png

SELECT T0.[U_Purchasing_Catagory] FROM OITM T0 WHERE T0.[ItemsGrpCod] = $[$4.0.0].

Please let me know why this FMS doesn't work and suggest changes.