Filters Source (delimitations)

You can set a Filter on a field to retrieve only the records that match 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 (on the left), and set either just the filter value or an SQL-like filter in FILTER (on the right). What you write on the right side depends on the DataSource.

• Filtering with Dynamics NAV SQL
• Filtering with MS SQL
• 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 another way to filter: Rapidi evaluates the filter (after the data has been read from the DataSource) and skips records that do not match it. These filters are called CheckFilters.

• Filtering with CheckFilters