Filters Source (delimitations)

Overview

• You can set a Filter on a field and hereby only have the records corresponding to the specified Filter value transferred.
• 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.
• Filtering with MS Dynamics NAV: write the value or range of values like inside Navision (e.g. 10000 or 10000..20000)
• Filtering with MS-SQL, DB/2, Oracle, MySQL: write a SQL where clause - like: Name = "BigShop"
• Filtering with salesforce.com
• Filtering with MS Dynamics CRM
• Filtering with MS Dynamics AX
• Filtering with MS Dynamics AXWS
• Filtering with Hubspot
• There is also another way of filtering, where RapidiOnline is evaluating the filter (after the data has been read from the DataSource) and skips the records that does not match the filter. These filters are called CheckFilters.
• Filtering with CheckFilters

 

Field:

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

 

Filter:

Here you specify the Filter value.