Article Property Sheet Where Clause Tab

The Where Clause tab lets you specify a Where clause to filter the table or view rows to replicate in a script editor.

Where clauses can help maximize application performance by reducing the amount of data replicated or control the availability of data by restricting its replication to specific subscriptions.

For example you could replicate all the data of the French HR department to the US headquarters, and use a Where clause to provide a filtered subset of this data to the Asia office.

Note:

Click the Open Auto Completion List tool or press CTRL and Space Bar to display a list of items and operators available for use in the clause.