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
API -Listing requests based on Additional Field Values
This can be met through V3 API. Go to Admin > Incident Additional Fields and make a note of the "API Field Name" as highlighted below: Please follow the below mentioned to pull the requests based on the additional field values: 1. Use the Input as ...Asset additional fields pick list values workaround.
There is an issue is that numerical values are shown in ascending order under the Asset picklist additional field. If a user complains about this specific issue, it is because Pick List values are stored as string in the database, so the fields are ...Parsing Request Description to Populate Additional Field Values
Use Case: When a user submits a request with a detailed description that contains structured information—such as issue category, priority, and location—the system can automatically parse this information and populate the corresponding additional ...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 ...Ability to mandate the reason for field updates in requests using custom triggers
Use case: At times, technicians may not provide the reason for request fields update as technician reassign, groups, priority and so on. This script will alert the technicians to update the reason for these request field updates. Prerequisites: ...