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