cancel
Showing results for 
Search instead for 
Did you mean: 

UDF value lookup

0 Kudos
60

When using my field on a offer layout, my UDF field shows the item rownumber instead of the item name.

The query behind the udf field in the offer screen looks like this,

SELECT T0.[Name], T0.[U_ORB_IMO_NR] AS "IMO Nr.", T0.[U_ORB_BOUWNR] AS "Bouw Nr", T0.[U_ORB_EXNAAM] AS "Ex Naam"
FROM [dbo].[@ORB_TBU_SCHEPEN_2]  T0

I added it to my print layout by choosing field source database -> table is offer -> column the UDF.

Also tried with enabling and disabling of the get Description field.

What am I doing wrong ?

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Query behind the udf means u have applied FMS , JUst check the query , if it gives more than one values then error prone data will come . So pls check the query .

Rgds,

Premraj

Answers (1)

Answers (1)

former_member187989
Active Contributor
0 Kudos

What data is actually entered in UDF,have u applied any formatted search ?

Run query,Check what data is retrieved from UDF Field of the table.