Connection Property Descriptions : ConfigOptions : MapSystemColumnNames (Configuration Option)

Try DataDirect Drivers Now

MapSystemColumnNames (Configuration Option)

Purpose

Determines how the driver maps Salesforce system columns.

Valid Values

0 | 1

Behavior

If set to 0, the driver does not change the names of the Salesforce system columns.

If set to 1, the driver changes the names of the Salesforce system columns as described in the following table:

Table 19. Mapped Names for Salesforce Field Names When Using MapSystemColumnNames
Field Name	Mapped Name
Id	ROWID
Name	SYS_NAME
IsDeleted	SYS_ISDELETED
CreatedDate	SYS_CREATEDDATE
CreatedById	SYS_CREATEDBYID
LastModifiedDate	SYS_LASTMODIFIEDDATE
LastModifiedId	SYS_LASTMODIFIEDID
SystemModstamp	SYS_SYSTEMMODSTAMP
LastActivityDate	SYS_LASTACTIVITYDATE
OwnerId	SYS_OWNERID

Default

0

See also