1. User Guide and Online Help
  2. Create and manage case series
  3. Create a case series
  4. Create a query-based case series

Create a query-based case series

You can create a query and include the cases found by the query in a new case series.

To create or edit a query-based case series, use the Query Wizard, which guides you through the process of selecting variables, selecting values, and specifying query logic.

Note:

If you edit and re-execute the query portion of a query-based case series to which cases have been transferred or added manually, Oracle Empirica Signal drops those cases from the case series if they do not meet the query criteria.
  1. In the left navigation pane, hover on the Data Analysis icon (Data Analysis icon), then select Case Series.
  2. Select Create Using Query Wizard.
  3. From the Configuration drop-down list, select a data configuration. You can select Browse to select from a list of data configurations.
  4. Select Next to define the query conditions.
  5. Select Select Variables.
  6. Select variables from the left-hand list and move them to the Selected Variables list on the right.
  7. From the Table drop-down list, select All Tables or a specific table.
  8. In the Match field, enter a variable to find.
  9. Select OK.
  10. Build the query on the Define Query page by selecting the values to include.
  11. Select Next.
  12. Review the data source and query logic. To preview the query results, select Preview Cases. This option is available only if you specified values for all variables and your user preference Show case count by default on preview page is enabled.
  13. Select Close, then Next.
  14. Save the query by specifying a name for the query. The name does not need to be unique, although Oracle recommends that you use a unique name.
  15. In the Description field, leave the description or add a description of the query.
  16. Choose one of the following:
    • To assign the case series to an existing project, select Add to existing project and select the project from the drop-down list. Only projects associated with objects that you created or that are published to you appear in the list.
    • To create a new project and assign the case series to it, select Add to a new project named and enter a project name.
  17. Select OK.

    Oracle Empirica Signal submits the case series to the background processing job queue. For larger datasets, the Background Processing indicator appears next to your user name at the top of the page.

    Note:

    The Background Processing indicator may not appear if you create a case series from a small data set that processes quickly.

Parent topic: Create a case series