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 > ...