Using UDF in Formatted Search

[Former Member]

Please tell me where my syntax is wrong:

declare @dte1 as datetime

Set @dte1 = (Select Case When $[$OINV.U_ORD_TYP] = 'S' Then 40450 Else cast($[$12.0.date] as int) End)

Select @dte1

If I use $[$4.0.0] to compare for a BP it works, but trying to compare using a UDF I get the very useful, Internal Error message.

Thanks.

[Former Member]

Hi,

What is this UDF property? Is this UDF for Document Type?

Thanks,

Gordon

[former_member186095]

Hi,

the error probably caused by the subquery result that returned more than 1 value.

Try to change the query by editing the FMS query

Rgds,

[Former Member]

Not the answer.

How can the value of a header level UDF be used in a formatted search?

[former_member362494]

Hi ,

instead of OINV.U_ORD_TYP , you should try : $[$U_ORD_TYP.0.0]

hope this helps