Publication Properties window: WHERE Clauses tab

Articles defined for MobiLink and SQL Remote publications use a WHERE clause to define a subset of rows of a table to be included in an article. This tab only applies and is only shown when the publication has a synchronization type of log scan.

The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.

This tab has the following components:

Articles list Select an article (a table) from the list of articles included in the publication.
The selected article has the following WHERE clause In the text box, type the WHERE clause for the table to restrict the rows that are included in the article.

The following example creates a single-article publication that includes all sales order information for sales rep number 856.

CREATE PUBLICATION pub_orders_samuel_singer
 ( TABLE SalesOrders
     WHERE SalesRepresentative = 856 );

Publication Properties window: WHERE Clauses tab

See also