Skip to Content
0

User Defined Field predefined values

Feb 28, 2017 at 07:33 AM

38

avatar image

Hi all


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

dd613.png (98.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Johan Hakkesteegt Feb 28, 2017 at 08:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded