Step 1: Create and edit a query

When you create or edit a query, the Define Query page appears. On the Define Query page, you specify conditions and link them with operators.

For information about operators, see Specifying query logic.

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, select a data configuration from the Configuration drop-down list or click Browse to select from a list of data configurations.
4. Click Next.
5. On the Define Query page, click Select Variables.
6. (Optional) If you want information about the variable shown, click Show Variables.
7. 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.
8. 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. If you point to the field name, a description of the field appears.

9. Choose one of the following:
   • If you are creating or editing a query from the Queries page or for an interactive report, you can specify values for each variable in the query. When running the query, you can change the specified values or enter values (if none were provided in the original query).
   • If you are creating or editing a query in the process of defining a database restriction, custom term, or case series, you must specify values for each variable or remove the variable.
     • The way in which you specify values depends on the type of variable. For more information, see Specify query values.
     • Each condition that you specify must be referenced by the query logic. If you are not going to reference a condition, you must remove the condition from the query, by clicking the [X] in the upper right corner of the box containing the variable.

   Note:

   You can include the same variable in the query multiple times. For example, cases for which the subject's age is between 17 and 25 or above 65. You include the AGE variable and set it to 17-25; include the AGE variable again and set it to above 65; then connect the variables with the OR operator.
10. Specify query logic by clicking Edit and entering a logical expression, referring to variables by their numbers, then click OK. For more information, see How to specify logic in a query.

    Note:

    If you add or delete another query variable after this step, the query logic is reset to a default.
11. If your user preferences include Show case count by default on preview page, you can check Display Case Count in Query Preview. You must specify values for all variables. Computation of the case count can be time-consuming, so we recommend that you display counts only when necessary.
12. Click Next to preview the query.