Picklists
A picklist is table of name-value pairs that specifies the valid values for a field. When you work with a picklist in the Microsoft Dynamics 365 user interface, you see a list of the descriptions. What is stored in the database, and what the API can understand, is a numeric value. The picklist feature of the adapter makes it easier to work with picklists when you are designing your DTS files.
Picklists provide these advantages:
- Enables you to see the allowable values for a picklist field without having to consult separate documentation. This information is accessed from Field Properties and does not need to be included in the field remarks.
- Enables you to set any picklist field by its value or name. This can simplify or eliminate data conversion formulas and make your DTS easier to understand.
- Validates a picklist field value before attempting an insert, update, or upsert, even though Dynamics 365 does not validate most picklist fields. Validation is set using Validate Dynamics 365 Picklist Fields in adapter settings.
TIBCO Scribe® Insight supports special functions for picklists. For example, the statuscode field for the open object has this picklist:
|
Value |
Name |
|---|---|
|
1 |
New |
|
2 |
Contacted |
Some picklists also have parent fields, whose allowable values are constrained by the value of another field.
For example, the allowable values for opportunity.statuscode are constrained by the value of statecode, as shown here:
|
Value |
Parent Value |
Name |
|---|---|---|
|
-1 |
Default |
|
|
1 |
0 |
In progress |
|
2 |
0 |
On hold |
|
3 |
1 |
Won |
|
4 |
2 |
Canceled |
|
5 |
2 |
Out sold |
See also