Filters Destination (delimitations)
Overview
- You can set a Filter on a field, so only records corresponding to the specified Filter value are 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 Rapidi should ADD the record or UPDATE an existing record. Setting a filter on the Destination will cause Rapidi to believe that certain records do not exist in the Destination, so it will ADD them to the Destination.
- One exception to the above is when "Delete" is selected. Rapidi will then read from the Destination and make a 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 Rapidi 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 Destination 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 on the right side depends on the DataSource.
- See Filters Source (Delimitations) for more information on specifying filters.
Field:
Here you specify which field the Filter should be set on.
Filter:
Here you specify the Filter value.