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?

                      • Related Articles

                      • How to populate requester details in request additional field

                        Requirement: Populate requester additional field information into request additional field. Usecase: Let us consider a scenario where certain employee details are imported from the Active Directory into User - Additional Fields. The business ...
                      • Request with ServiceCatalog Additional fields

                        Service catalog additional fields are category specific fields. These fields are stored in a dynamic table, so we need to join the specific template to get the resultant.  To make any changes to a query, refer to the KB article below. ...
                      • How to populate user names in a request additional field

                        This sample script is to populate both technician and requester names in a request additional field Use Case: Populate all user name in a request additional field. Execution Steps:  1.  Create a new 'Single Line' additional field and add them in the ...
                      • Dynamic checklist based on field values

                        Requirement: Based on the answers provided for resource questions / request additional fields, dynamically a checklist has to be associated to the request UseCase: When an alarm is received indicating an issue with a server’s performance, with the ...
                      • Set Task Owner depending on the request field values

                        Requirement: Set Task Owner depending on the request field values. Usecase: When a task is triggered from a request, it should be assigned to a technician depending on the request field values. Steps to follow: Goto Admin > Task Custom Functions > ...