Documentum Connector 23.2

# 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: |

Copyright 2023 Open Text
Version 23.2 | Last updated March 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Documentum Connector 23.2

Topic Title: Incremental