Step 5: Run a query

Each time that you run a query, Oracle Empirica Signal executes the query. Even if you do not change values for variables in the query, if the source data changed since the last time you ran the query, the query results can differ from when you last ran the query.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Queries.
2. Click the query's Row Action menu (), and then click Run.

   Note:

   When you run an interactive report, you also run a query.
3. From the Configuration drop-down list, select a data configuration from a list of compatible data configurations. This is the source data against which the query runs.
4. Click Next.
5. On the Run Query page, specify values for query variables. For more information, see Specify query values.
   If the operators in the query are all AND, all OR, all INTERSECT, or all UNION, you do not need to specify values for every variable. If you do not specify a value for a variable and you do not check Include Null values for the variable, then the application ignores that variable. If all of the operators in the query are MINUS or if you use a mixture of different operators in the query, you must specify values for every variable.

   Note:

   You can set up a query-based interactive report to use query values as breakdown details. If a column or row variable has no breakdown values because you do not supply query values when running the report, the application drops the column or row from the report. If the resulting report has no rows or no columns, you cannot run the report until you supply query values.
6. Click Next.

The cases matching the query appear on the Cases page. See View query results.