If you are familiar with SQL, you know that the order in which the clauses are presented in a query string is not the order in which they are processed. For example, here is a fairly complex example formatted to make each clause distinct:
In fact, the clauses are processed in the following order, as shown in Figure 1, How a Query String is Processed: from (including stream clause), where, group by (including having), select.Of special interest is how the where clause in the stream policy operates with the main where clause; and how the stream policy can create multiple windows.Figure 1 How a Query String is Processed
Copyright © TIBCO Software Inc. All Rights Reserved.