Defining data filters
Data filters are defined with SQL conditions set on the SQL tables associated to the application.
When collecting data from the central database, the DB Sync server only selects the data rows matching the data filters.
The SQL conditions can be parameterized by using %DBSYNC_XXX%
placholders. The
parameter values can be customized for each end user.
Data filters are defined in the bottom right of the app configuration tool.
The below example adds a data filter for author
SQL table:

Select a column from the drop down, click on the [+] button to add the column name to the SQL condition and complete the SQL condition. Click Save to apply the data filter.
To test the data filter, navigate to the the GIP console application program and append the SQL
parametre name (without %
delimiters) and value to the GIP user's properties.
The below example shows properties of the user modified to apply to the author Dan
Brown
:

For more information on data filters, go to Data filters.