Filter

When loading data from tables or views, you can specify a SQL "where" clause in this field to restrict the data to be sent in a BOD. This filter applies only when the BOD is loaded by running the Replication Document Manual Request Utility.

The following example filters the data so that the BOD includes only records where the status property's value is set to "working":

status="working"

The filter text must stand by itself and not conflict or be changed if the system uses AND clauses to join it to other filter rows, for example:

where status="working" AND filter row 2 AND f ilter row 3 ... AND filter row N

This field is disabled when the Document Name includes "delete".