Selecting query values

In this section ShowHide

The way in which you specify values depends on the type of variable.

• If the Select <hierarchy> Terms link appears for a variable, click it to select terms from the hierarchy. For example, if an event variable is associated with a MedDRA account and your user preference, Enable Adverse Event Hierarchy Browser, is checked, you can click Select MedDRA Terms.
• To select values from a list, click Select Available Values.
• To refer to a saved list of terms, click Select Saved List. You can specify a saved list that uses the same data configuration as the query.

• To type the terms, review the rules in Typing values in text boxes.

Note: To prevent spelling and capitalization errors, Oracle recommends that you select rather than type values.

• To look up a drug name for a drug variable, click Trade/Generic Lookup. You can find the generic name for a drug (if you only know its trade name) or vice versa. (This link is available if the data configuration's source data included trade name-generic name mapping.)

Matching a text string

If the options Contains, Starts with, Ends with, or Equals appear for a variable, enter a text string and select an option to indicate the type of matching. You can also check Ignore capitalization to retrieve matching values regardless of upper or lower case.

Specifying ranges

For numeric or date variables, specify a range by entering From and To values. Values equal to or greater than the From value and equal to or less than the To value are found. If you leave the From field empty, there is no lower bound. If you leave the To field empty, there is no upper bound.

If a date variable is stored as a date field in the source data, you must enter the date in the format MM/DD/YYYY or use the calendar icon to select a date.

If you do not specify a time, the application considers the time to be midnight of the specified date.

Note: If a date variable is stored as a text field in the Oracle database, you can search for it as you would search for any text string.

Specifying report IDs

For a variable specified with the type Report ID in the data configuration, you can enter a string of report IDs separated by commas.

Check Include Null values to include null (empty) values along with the other values that you specify for a variable, and click Next. For more information, including how the NOT operator works if you include null values, see Specifying query logic.