Offline Replication Filter Dialog Box

See Also

Specifies criteria for filtering the data for your offline publication. You can create a simple set of criteria for a filter using the expression builder drop-down lists, or you can build more complex criteria using SQL syntax.

To create a filter, select a main table to filter on the Filter Items tab, and then enter one or more filter clauses that compare columns in the table to some value. Only the rows in the main table that match the criteria will be replicated. For information on the T-SQL programming language, see the SQL Server Books Online.

Options

Expression

Use the drop-down boxes to create a filter. Click Add to add the expression to the SQL statement box.

For details about filtering operators, see Offline Publication Filtering Reference.

SQL Statement field

When you click Add, an SQL statement is created based on the fields specified in the Expression area. After the expression is copied in the SQL area, you can modify it or click OK to add the filter to your publication. You can also type SQL statements directly into the SQL area.

Where to go from here

For information about See
Setting up criteria to filter the data for the publication Filtering Offline Data for a Publication
Making your team solution available offline Allowing Users to Work Offline
Requirements and guidelines for creating offline publications Planning Offline Capabilities
Defining a table hierarchy for your solution database Setting up a Table Hierarchy