When you search for forms in OneData, keep in mind the following points:
- Searches are not case sensitive. Searches for
Gene
andgene
return the same results. - In any editable text field, enter a search string, complete or partial. This does not apply to numeric fields such as Public ID.
- In any editable text field, you can use a percent sign (%) as a wildcard. For examples, refer to Using Wildcards - 2021-06-09.
- For some fields, you can adjust the search scope (with options such as NOT LIKE, Exact Phrase Match, All Of The Words, or One Of The Words) by clicking the Advanced Filter icon.
- The system processes search criteria as AND statements, so the results include only forms that fulfill all the criteria.
- To reset a list of values, click the Clear Values icon next to that list.
- You can specify the number of results returned: Type a number in the Number of Rows field and press <Enter>.
- When you remove or change search criteria, the system does not update search results until you click Apply Filter again.
To perform a data element search:
- Open a supported browser:
- Chrome
- Firefox
Navigate to the following portal:
https://wmonedata.nci.nih.gov/
The home page appears. The home page appears, with objects you have specified as favorites in the Favorites panel (if any).
From the View menu, select Browse and then select Forms. The Forms page appears. (For instructions on adding this page to your favorites, refer to Managing Your Favorites - 2021-06-04.)
Specify one or more search criteria, as described in the following table:
Field Instructions Form Name Type all or part of the form name. (To adjust search scope, click the Advanced Filter icon.) Public ID Specify the full numeric value for a single form public ID. (You cannot use wildcards in numeric fields.) Owned By Select one or more of the contexts that have administrative authority to edit and update the form. Registration Status Select one or more registration statuses. For details, refer to Registration Status - 2022-01-10. (To adjust search scope, click the Advanced Filter icon.) Workflow Status Select one or more workflow statuses. For details, refer to Workflow Status - 2022-01-10. (To adjust search scope, click the Advanced Filter icon.) Latest Version Select one of the following options: - To search for the latest version of the form, select Yes.
- To search for all versions except the latest version, select No.
- To search for all versions, clear this field. (That is, set it to Select Value.)
Created By Select the person who created the item. You can select one or more people. Last Modified By Select the person who last modified the item. You can select one or more people. In the fields that have a Select a Value icon, you can select one or more values. Click the Select a Value icon next to the field. A Reference Data Panel appears.
- To select one value: Click the value name. The value name appears in the field.
- To select one or more values: Click the checkbox for each row you want to include. Click Set Values. The field indicates how many values you have set.
For date criteria, click the Audit Columns icon and specify dates as described in the following table:
Field Instructions Date Created Click the calendar icon and select the date on which the item was created. Date Last Modified Click the calendar icon and select the date on which the item was last modified. To adjust search scope, click the Advanced Filter icon and consider the following options:
The list to the left of each date field allows you to search for items later than (>), earlier than (<), and/or equal to the date you specify.
- The list to the right of each date field allows you to specify whether the date field is NULL or NOT NULL.
- The check box below each date field allows you to specify a date range.
- You can also create your own query to search, by specifying an explicit "where" clause.
- Click the Advanced Filter icon.
- Under Filter Options, select a column and then click >>. The name of the selected column appears in the text box.
- Complete the query string. (For example, if your query string is "a.CURRNT_VER_IND=1" when you click Apply Filter, the system returns all items of the latest version.)
If necessary, you can specify additional criteria using a child filter. For details, click one of the following links:
Click Apply Filter. The system displays the search results. By default, the system also hides the search criteria.
To view details about a form, click the value in the Form Name column.