) for the query, and then click Run.When you run a query, the application retrieves a list of cases matching the query criteria.
Each time that you run a query, the application re-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. Click the Queries tab.
The Queries page appears. For more information, see Queries page.
2. Click the row menu () for the query, 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.
The Run Query page appears.
5. Specify values for query variables. For more information, see Selecting query variables.
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.
If you are running a query from the Queries tab, the query results appear. See Viewing query results.
If you are running a query for an interactive report, the query generates a list of cases against which the report is run. See Viewing a report.