Step 2 (Optional): Specify query logic

When you specify conditions in a query, they are connected using default operators. You can modify the operators as needed.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Queries.
2. At the top left of the Queries page, click Create Using Query Wizard.
3. On the Select Configuration page, from the Configuration drop-down list, select a data configuration or click Browse to select from a descriptive list of data.
4. Click Next.
5. On the Define Query page, click Select Variables.
6. From the All Variables in All Tables list, select one or multiple variables on which to base conditions and use the right-arrow button to move them to the Selected Variables list.
7. Click OK.

   A field for each variable you selected appears on the Define Query page. Oracle Empirica Signal assigns a number to each variable. When you specify query logic, you use that number to refer to the condition that is based on that variable.

8. Specify values for each variable.
9. Click Edit.
10. Specify query logic by entering a logical expression, referring to variables by their numbers. Use logical operators and set operators.
11. Type in logical operators, set operators, and parentheses as needed.
    • The conditions in a query must be joined by the AND, OR, INTERSECT, UNION, or MINUS operator. The NOT operator is available to negate a condition (for example, 1 AND NOT 2).
    • Each condition must be referenced by the query logic at least once. You can refer to the same condition multiple times in a query. For example, you can specify: (1 AND NOT 2) OR 2.
12. Click OK.