To Create a Stream Projection and Filter Operator

1. Drag a Stream Projection and Filter operator from the Palette to the Design view.

2. Connect the output of an operator that has stream output to the input of the Stream Projection and Filter operator.

3. (Optional) Connect the output of one or more operators that have relation output to the input of the Stream Projection and Filter operator.

4. (Optional) Connect the output of one or more operators that have table output to the input of the Stream Projection and Filter operator.

5. Double-click the Stream Projection and Filter operator.

   The property editor opens.

6. If you want to change the default name, then change the value in the Name field.

7. In the SELECT area, populate the table with one or more attributes.

   By default, the SELECT area contains only one attribute row. To create additional rows, click Add Attribute.

   You can drag and drop attributes from the tree structure into the Expression column. If you use this approach, then the operator name is automatically added to the FROM area.

8. In the FROM area, specify the names of one or more input operators.

   You can drag and drop operators from the tree structure into the FROM area.

   You can specify an alias for a table (for example, TableInput0 t) and then use the alias in the WHERE clause. You cannot specify an alias for a stream or a relation.

   If you specify more than one operator name, then separate the names with a comma (for example, StockTransactions,RollingAvgPrice).

9. (Optional) In the WHERE area, specify a search condition in the form of a boolean value expression.

   You can drag and drop operators and attributes from the tree structure into the WHERE area.

10. Click OK.