Use the WHERE clause as a filter on an output window.
The example creates an input window named TradeWindow and an output window named TradeOutWindow.
The SELECT clause returns all (*) data rows from TradeWindow. The WHERE clause places a filter on the data when the share volume is less than 10,000. As a result, the project server processes all data rows when the TradeWindow contains more than 10,000 shares.
CREATE OUTPUT WINDOW TradeOutWindow SCHEMA ( Ts BIGDATETIME, Symbol STRING, Price MONEY(2), Volume INTEGER) PRIMARY KEY (Ts) AS SELECT * from TradeWindow WHERE TradeWindow.Volume > 10000;