Older(1)Newer (0)Hide changes
AutoSave posted by Michael Bock on February 18, 2015 18:25:32

Showing changes from revision #1: Added | Deleted

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]]
  • 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.

 

  1. Getting Started
  2. Documentation
  3. HowTo
  4. Standard Integrations

 

Service News can now be found on our Product Updates Blog 

 

Remember to Subscribe to our Product Updates Blog to receive updates and product news.

 

 

 

 

Wheeled by Wagn v. 1.9.1