Enabling Retrieval of Display Values (Service Now Source Only)

Enabling Support for Source Display Value Mappings

When creating or opening a project with Service Now source, the project properties options tab contains an option to Support Source Display Value Retrieval. This option is only available where the source server is Service Now, and it is checked by default for projects with a Database Target Server (Archiving Projects) 

This will cause fields that contain both a 'source data' value and a 'display' value to have two mappable fields. The display field will be labelled with the (display) suffix and named with the dv_ prefix. Note that only certain fields support a display value. Display values always have the type 'String'

Field Types that Support a Display Value.

The following ServiceNow field types support a display value:

Field Type	Source Value	Display Value	Notes
Reference	the 32 char sys_id of the referenced record	The display field value of the referenced record
List	A comma delimited list of  the sys_id's of the selected records.	A comma delimited list of the display field value of the selected records
Choice (or fields that have choices defined)	The string value of the selected choice. This may be an integer in many cases.	The label value of the selected choice
True/False	true or false boolean values	'True' or 'False' strings
Journal Journal List	this will always be empty and should not be mapped	A formatted list of all journal entries in the list. Each entry will include the submitter, timestamp, type and comment

Execution Time Performance

At execution time, PB will determine whether the source, display or both values need to be retrieved for a given form mapping. If a mixture of source fields and display fields are used in the field mappings, both source and display values are retrieve for ALL fields (This is a limitation of the Service Now API). This will make data retrieval at execution time slower, typically by 10-50%