cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted Search syntax in UDF

Former Member
0 Kudos

Good day

I have created siple formatted search to link a Sales Order number to the Incomming Payment header

SELECT T0.[DocNum] FROM ORDR T0 WHERE T0.[CardCode] = $[$5.0.0] and T0.[DocStatus] = 'O'

When I run the Formatted Search to the Reference field it works perfectly, but if i run it in a UDF on the header I get no result. Can you please tel me how the syntax must change to work in a UDF?

Erika Boshoff

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The correct syntax is $[$-5.0]