Get Description from UDF (List of Values) in Item Master

[jane_liang]

Hi,

I am trying to get the Description from a UDF in Item Master for which I have created a List of Values.

How do I write a query to return the description from the UDF. My UDF name is u_stage.

I saw a previous post where the UDF was in the row level of a marketing document and the solution did not work for this scenario.

Thanks, Jane

[Former Member · Accepted solution]

Hi Jane,

Please check this thread:

Thanks,

Gordon

[jane_liang · Accepted solution]

Thank you!

[keith_taylor2]

How to display the name instead of the codes for user defined fields:

SELECT T0.ItemCode, (select T1.[Descr] from UFD1 T1 (nolock) join dbo.[CUFD] T2 on T2.[TableId] = T1.[TableId] and T2.[FieldId] = T1.[FieldID] and T2.[TableId] = 'OITM' and T2.[AliasId] = 'Brand' where T1.[FldValue] = T0.[U_Brand]) FROM [dbo].[OITM] T0 (nolock)