Search our Wiki
Filters Source (delimitations)
Overview
You can set a Filter on a field and retrieve only the records that correspond to the specified filter value.The way you set up the filters depends on the data source or the source system 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 NAME (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.
You can set a Filter on a field and retrieve only the records that correspond to the specified filter value.The way you set up the filters depends on the data source or the source system 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 NAME (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 Microsoft Dynamics 365 Sales
- Filtering with Microsoft Dynamics AX
- Filtering with MS Dynamics AXWS
- Filtering with Hubspot
- Filtering with ODATA
- Filtering with Microsoft Dynamics 365 Finance and Operations
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.