Skip to Content
avatar image
Former Member

Formatted Search on UDF Hour glass option not working

Hi I have the following formatted search;

SELECT T0.Free_Text

FROM OCRD T0

WHERE T0.CardCode = $[$4.0.0]

The FS works when refreshing values regularly and when Display Saved User - Defined Values based on Customer/vendor code.

When using Display Saved User - Defined Values it will only work on new documents created.

When trying to refresh using only the hour glass this does not work and is how I need it to work.

My FS search is simple populate the UDF in ORDR if the CardCode from OCRD = CardCode in ORDR.

I test the query and it is working just not populating when I press the hour glass.

Thanks for the help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 05:20 PM

    Solution:

    change the FS:

    SELECT T0.Free_Text

    FROM OCRD T0

    WHERE T0.CardCode = $[OCRD.CardCode]

    Add comment
    10|10000 characters needed characters exceeded