Articles defined for MobiLink and SQL Remote publications can use a WHERE clause to define a subset of rows of a table to be included in an article. UltraLite applications can use row subsets by supplying a WHERE clause, with one exception: articles in UltraLite publications governing HotSync synchronization cannot use a WHERE clause.
The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.
The WHERE Clauses tab is only shown if the publication that contains the articles has a type of log scan.
The WHERE Clauses tab of the Publication property sheet has the following components:
Articles list Select an article 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 )
See Publishing only some rows using a WHERE clause.