Operator Guide

Back Next

Subscription Filter Properties

The

Filter

page of the subscription wizard can include the following properties:

Basic Expression: Use this method if you want to apply a condition to a table row and the operators and values in the basic condition builder meet your requirements. For example, for an Orders table, add a condition that the date in the ShippedDate column is greater than April 1, 2015.
Advanced Expression: Add filter conditions to tables with PowerCenter expressions. For example, for an Orders table, add the following expression:

(ShipCountry=’USA’) and ((ShipCity=’New York’) or (ShipCity=’Los Angeles’))
Condition list: Select the table for which you want to define a condition and define the expression. The properties that show in the list depend on the type of expression that you select.