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.

          • 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 ...
          • Associate Checklist for a Request depending on Resource/UDF Values

            Requirement: Script to associate checklists depending on UDF Additional field values/Resource Question values. Usecase: In few organizations. they have a separate template for "New Asset Request".  Each new asset needs a different set of checklists ...