User Defined Field predefined values

[kedalenechong]

Hi all

How to list User Defined Field values predefined in User Defined Fields Management Update?

[Johan_H]

Hi Kedalene,

It is a bit tricky, but with this query it can be done:

SELECT T1.FldValue, T1.Descr
FROM CUFD T0
     INNER JOIN UFD1 T1 ON T0.TableID = T1.TableID AND T0.FieldID = T1.FieldID
WHERE T0.TableID = 'ORDR' /* <-- the name of the table the UDF is in. */
  AND T0.AliasID = 'type' /* <-- the name of the UDF without U_ */

You need to mention the TableID in case you have more UDFs with the same name in other tables. UDFs in document tables are even automatically copied for each document table.

Regards,

Johan