Incremental

Enter false to fetch all documents every time the connector runs.

Enter true to fetch only documents that are new or have been modified since the last connector cycle.

If you enter true, the connector behaves as though Incremental=false for the initial run.

For new and modified documents, it queries the dm_audittrail table for entries with event_name 'dm_checkin' or 'dm_save' (or dm_audittrail_acl table entries with event_name 'dm_save') restricted by time_stamp read from time file.

For deletions, it queries the audit trail table for entries with event_name 'dm_destroy' or 'dm_prune' restricted by time_stamp read from time file.

The DQL query for new/modified object IDs appears below as an example:

SELECT DISTINCT(dm_document.r_object_id) FROM dm_document
WHERE
(
  dm_document.r_object_id IN
  (
     SELECT dm_audittrail.audited_obj_id FROM dm_audittrail
     WHERE ((dm_audittrail.event_name = 'dm_checkin')
     OR (dm_audittrail.event_name = 'dm_save'))
     AND (dm_audittrail.time_stamp
       > date('<dateString>','dd/mm/yyyy hh:mi:ss'))
  )
OR
  dm_document.acl_name IN
  (
     SELECT dm_audittrail_acl.object_name FROM dm_audittrail_acl
     WHERE (dm_audittrail_acl.event_name = 'dm_save')
     AND (dm_audittrail_acl.time_stamp
       > date('<dateString>','dd/mm/yyyy hh:mi:ss'))
   )
)
AND additional_configurable_criteria
Type: Boolean
Default: False
Required: No
Configuration Section: TaskName or FetchTasks
Example: Incremental=true
See Also: