Inclure automatiquement les valeurs définies par l'utilisateur dans la table de base ou ajouter des variantes avec des valeurs transposées

Idées (en)
,
1

See How do I access Autotask UDFs (user defined fields) for contracts?.

It would be handy when the views are always present with the correct list of User Defined Fields retrieved from the entity information (such as ContractsEntityInformationUserDefinedFields@at):

--create or replace view ContractsWithUDFValues
--as
select *
from   Contracts_ItemsUserDefinedFields cttudf
pivot   ( max(cttudf.value)
          for cttudf.name in
          ( [VALUE-OF-name-COLUMN-FOR-CUSTOM-FIELD-1]
          , [VALUE-OF-name-COLUMN-FOR-CUSTOM-FIELD-2]
          , [VALUE-OF-name-COLUMN-FOR-CUSTOM-FIELD-3]
          , ...list all custom field names from entity information...
          )
        )
How do I access Autotask UDFs (user defined fields) for contracts?