Filtering in Synchronization Packages
0 for No, 1 for Yes
Integer value of option value beginning with 0 for first option value
Fixed syntax Year-Month-Day: YYYY-MM-DD
Fixed syntax Hours:Minutes:Seconds: HH:MM:SS
An apostrophe (inverted comma) must be escaped with a second apostrophe.
The Anveo Delta Server support simple operators like smaller than < and ”smaller with two points and & and or |.
Complex structures using brackets are not supported. In case you need a complex filter, please add the same tables multiple times to your Synchronization Package.
In addition to the filters, you can set up in the user interface using the function Edit Filter, you can also use filters, which depend on the relation type and relation code of the Anveo User (see Anveo User Properties). In this way it is possible to only transfer the data to a Anveo User’s device, which he is allowed to see.
Simple Filter Based On Anveo User
For example you can set in the field No. of table Customer the following filter: %CUSTOMER
Complex Filter Based On Anveo User
If you want to combine a dynamic with a static filter, you can enter the following:
If the Anveo User has the relation type Customer, the part between %IFCUSTOMER and %END will be evaluated in the filter and additionally appended. The variable %CUSTOMER depicts the value of the relation code of the Anveo User. If the Anveo User has the relation type Customer and the relation code 30000, the filter defined above will be evaluated to:
In another relation type of the filter evaluates to:
Overview Of User Based Filters
You can use the following keywords for user-dependent filters in synchronization packages:
- %USER for relation type = user
- %CUSTOMER for relation type = customer
- %VENDOR for relation type = vendor
- %CONTACT for relation type = contact
- %SALESPERSON for relation type =
- %EMPLOYEE for relation type = employee
- %RESOURCE for relation type = resource
- %RESP_CENTER for relation type = responsibility center
- %CUSTOM1 for relation type = Custom 1
- %CUSTOM2 to %CUSTOM5 like Custom 1
- %ANVEOUSER to filter on Anveo User code
Date Filter For Ledger Entry Tables
Dynamic Date Filter
To optimize the amount of data of ledger entry tables like Customer Ledger Entry, you can define a dynamic date filter on the Posting Date field. This allows you to limit the data for example to the last three months only.
%-30D.. for the last thirty days until today
%-3M.. for the last three months until today
The following values are supported:
Days D, Months M, Weeks W, Quarters Q, Years Y, Hours H, Minutes MI, Seconds S and current date TODAY.
Static Date Filter
A static date filter can be set using the following syntax:
2014-08-01..2014-08-31 for August 2014
2014-09-01.. from September 1st, 2014 until today