User defined fields window / formatted search

[Former Member]

HI

I 've created a user defined field in the marketing documents

I want tO put the result of a query into this field :

I use a formatted search in order to have the result :

SELECT T0.Balance FROM OCRD T0 WHERE T0.CardCode = $[$4.0]

My query is based on CardCode(item 4), but when the user defined field window is open, the item 4 is the cross of this form and i have the result next :

SELECT T0.Balance FROM OCRD T0 WHERE T0.CardCode = N'RSRCButtonCloseBox'

Thanks

Sylvain

[Former Member · Accepted solution]

Hi,

I think it should be:

SELECT T0.Balance FROM OCRD T0 WHERE T0.CardCode = $[$4.1.0] for browse

Success

[Former Member]

Hi,

It happened the same today for me, but using both, $[$4.0.0] and $[$4.1.0]... both of them return that RSRCButtonCloseBox....

So, what is wrong here?

Regards,

Leo