Filter Type, Scheduler Subjob Filter

This field contains the type of filter being created. The options are:

Const - The value in the Value 1 field determines the filter being used.

Filter - The criteria set up in the Value 1 field determines the filter being used. See: useoverview_8032 for further reference of valid criteria for the Replicator. For the Data Director the valid criteria depend on the database type you are connected to. This option is usually only supported when the source database is Microsoft Dynamics 365 Business Central database.

From Location - The program uses the From-Location code from the relevant Scheduler Job Header.

To Location - The program uses the To-Location code from the relevant Scheduler Job Header.

Warning - If the job has many receivers this option creates massive overhead and should never been used if the stores being replicated to are many. At least, if this option is used we highly recommend to separate subjobs using this option to a specific job.

The following options are only supported by the Data Director.

< (less than) - Uses the Value 1 field to apply the filter < Value 1.

> (greater than) - Uses the Value 1 field to apply the filter > Value 1



[..] (range) - Uses Value 1 and Value 2 to apply the filter Value 1 .. Value 2.

min (minimum) - Filters on the records having lowest value in the relevant fields.

max (maximum) - Filters on the records having the highest value in the relevant fields.

D-Range (dynamic range) - Same as [..] but the values in Value 1 and Value 2 are updated after each successful run. The interval between the both values is used to create new filters after each run.

Example
Configure this filter with Value 1 = S001 and Value 1 = S010. The values will be updated as follows:

Run 1: Value 1 = S011 and Value 1 = S020

Run 2: Value 1 = S021 and Value 1 = S030

Run 3: Value 1 = S031 and Value 1 = S040