You can set a Filter on a field and hereby only have the records corresponding to the specified Filter value transferred.

When setting the filter on the destination, you need to take extra care, as this will limit the records that RapidiOnline can see when it does a lookup in the destination to see if a record exists or not - i.e. if RapidiOnline should ADD the record or UPDATE an existing record. Setting a filter on the Destination will hence make RapidiOnline believe that certain records does not exist in the Destination and so it will ADD them to the Destination.

One exception to the above is, when "Delete" is selected. Then RapidiOnline will read from the Destination and make lookup in the Source to see if a record still exists (and hence if it should delete the record or not). When using "Delete", a filter on the Destination will limit records that RapidiOnline reads in the Destination and thereby what records it potentially deletes.

How to set the Filters depends on the DataSource that the filter is used on (for Source Filters, the Source DataSource and for Destination Filters, the Detination DataSource).

In general you will select the field name to filter on in "Field" (the left side) and set either just the filter value or write an SQL like filter in the "Filter" (on the right side). What you write in the right side, depends on the DataSource.

See Filters Source delimitations for more information on how to specify filters.

Field:

Here you specify which field the Filter should be set on.

Filter:

Here you specify the Filter value.