Additional field values

Additional field values

This report helps to find the picklist values in the additional fields.

First you need to find the name of the table and the column holding the data, by executing the following SDP query report: 

SELECT Tablename,
       Columnname FROM ColumnAliases
WHERE Aliasname='Services'

Then you can retrieve the pick list values. For example: 

SELECT Value FROM UDF_PickListValues
WHERE Tablename='WorkOrder_Fields'
  AND Columnname='UDF_CHAR36'

Replace WorkOrder_Fields and UDF_CHAR36 with the values returned by the first query.




                  New to ADSelfService Plus?