Skip to Content

User Defined Field predefined values

Hi all


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

dd613.png (98.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 28, 2017 at 08:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded