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 ...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 ...Query to display additional field associations with templates (MSSQL)
Tested in build MSSQL (14306) Use case The reports shows in which templates the created additional fields are associated Query select sd.name "Service Catalog Name", rt.templatename "Template name", fc.field_name "Fields" from requesttemplate_list rt ...Script to Populate User Additional Field under Incident Template using FAFR
The script load the Requester Name under Incident Additional field ( As a pick list), by choosing the requester name under additional field the script populates the user additional field value. * Kindly create two additional fields under Admin -> ...How to import user additional fields using LDAP
In order to import additional fields or map any other fields in AD to the system fields, a row needs to be updated with the appropriate values You can follow the below steps 1. Take a trimmed backup of the database. 2. Connect to the Database 4. Run ...