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

_FT_HTML5_bannerTitle.htm