Synchronization Server Help


Defining a data filter

Suppose that you provide database administration services for several hospitals in your state. For administrative purposes, patient statistics are kept in a master table that rolls up data from all hospital sites that you administer. Nurses and doctors within each hospital need access to the PATIENTS table, but they need only rows for the patients in their hospital. To handle the needs of each hospital, you could create different views on the table and then create a separate subscription for each view; however, this approach could be time-consuming if you have multiple groups. Instead, you can create a data filter that specifies the subset of data that each group can access.

These steps are part of the larger task of creating a group or editing a group. When you complete the steps for defining a data filter, return to the main task.

Figure dsyh018 not displayed. Fields and controls


Figure dsyh016 not displayed.

To define a data filter for a group:

  1. On the Data Filter page of the Create Group notebook, click Add. The Add Data Filter window opens.

  2. In the Parameter name field, type the name of the column in the table that you want to filter. The name is case-sensitive.

  3. In the Default value field, type the value that will serve as the default filter criteria.

    If you assign a data filter for an individual user in the group, the user filter values override this default.

  4. Click OK. The parameter-value pair appears on the Data Filter page.


Figure dsyh016 not displayed.

Related information

[Return to creating a group or editing a group]


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]