Overview of creating a query in the Design tab
After you add a query file to a project, the Query Designer appears. You can define the query in the Design tab.
Note: | By default, the query designer notifies errors at table level for Inputs and Pattern sections before entering data. After entering data, if there are errors in any section, the errors are notified at the table level as well as row level of the table where there is an error. |
Before you can define a query, you must define the events that you want the query to process. For information on how to write the event definitions, see
Overview of query application components.
To defining a query in the Design tab of Query Designer
1. In the
Inputs pane, click the plus sign to add an event type definition that you want the query to process. You must add one or more inputs before you can create the event pattern you are interested in. See
Adding query inputs .
3. From the event
Palette, select an input event and drag it onto the pattern canvas. See
Adding query patterns.
4. In the
Actions pane, click the plus sign to define an action that the query executes when it finds the specified event pattern. See
Adding query actions .
5. Optionally, In the
Conditions pane, click the plus sign to add a filter, time constraint or exclusion. Conditions let you identify the exact events you are interested in. You must add one or more inputs before you can add query conditions. See
Adding query conditions .
6. Optionally, in the
Aggregates pane, click the plus sign to add an aggregate expression to the find pattern. An aggregate expression aggregates event field values in order to find data based on many sets of events. See
Adding query aggregates.
At any time, you can click the Source tab to view the code that defines your query.