Formatted search for production order

[shikin]

Hi all,

I am trying to create one formatted search for production order UDF. We have our own sales order configurator table so whenever remarks at the configurator change then at production order extended remarks UDF will reflect also. Please refer below screenshots:

table name for our sales configurator is ft_config_bom and inside the table contain this info:

and my formatted search query is like this :

SELECT T0.[remarks] FROM ft_config_bom

T0 WHERE T0.[ItemCode]= $[OWOR.itemcode] and T0.[LineNum] =$[OWOR.U_Linenum]

but the outcome when i click on the magnifying icon displays like this:

I don't want my users need to choose like this, become tedious works for them. Can someone help me? Thanks.