Use the Find feature

Use the Find feature to search on column values in the current records.

1. After you select a study, click Data Management in the navigation bar.

   Note:

   For details on selecting a study, see Select a study from the Home page.
2. Select Listings from the drop-down menu.
3. Expand one of the listings in the left panel (Default Listings, Custom Listings, or VC Listings). Then, expand a clinical data model from the list.
4. Select a listing to open it.
5. Click inside the Find in Column field at the top of the table to open the Columns drop-down list.

   Tip:

   You can skip the remaining steps and use keyboard shortcuts to access the Find field by pressing Ctrl+Alt+S. Start typing a word and press the space bar to open the drop-down list. Then use the arrow keys to select an option. You can press the space bar again to open more options and build an equation. When done, press Tab to navigate to the Apply icon and press Enter.

6. Press the space bar to open the Operators drop-down list. Build the find criteria you need. For example, you can select equals (=), contains, starts with, greater than or equal to (>=).

   To enter text (string values), add single quotes around the text (for example, 'Boston').

   Tip:

   When searching or filtering with string values, we recommend using the contains operator. This is because Oracle DMW allows multiple spaces (such as leading and trailing blank spaces) in data displayed on the Listings and Discrepancies interfaces.
7. Click the Apply icon to apply the find. (Click the Clear icon to clear the Find criteria.)