Specifies whether to include deleted and archived records in standard SELECT queries.

Data Type

bool

Default Value

false

Remarks

By default, Certinia excludes deleted and archived records from query results. When ArchiveMode is set to true, the connector uses an alternative query behavior that includes these records. This corresponds to Salesforce’s queryAll operation, which retrieves both active and soft-deleted records that are not returned in standard queries.

This setting is useful for retrieving deleted records before they are permanently removed, accessing archived data for historical reporting, or performing audits that require a complete dataset.

Performance Considerations

Deleted records retrieved with queryAll behavior remain available only until they are permanently removed, typically 15 days after deletion. Including deleted and archived records may increase API usage and result in a significantly larger dataset, which can impact query performance. If only active records are needed, keeping ArchiveMode set to false helps improve efficiency by avoiding unnecessary data retrieval.