Page History
When you search for administered items in OneData, keep in mind the following points:
- CDEs follow the ISO/IEC 11179 standard, so you can search for data elements using ISO/IEC 11179-based attributes.
- For each field, the default is all values. For example, in the Latest Version field, the default behavior returns all versions.
- 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.
- For some fields, you can adjust the search scope (with options such as IS NULL, IS NOT NULL, 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 items that fulfill all the criteria.
- To reset a list of values, click the Clear Values icon next to that list.
- If you clear a field, or if you leave a field at its default setting, the system does not limit the search by that criterion.
- 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 search:
Excerpt | ||
---|---|---|
| ||
Started drafting instructions. |
Log in as described in Logging In - 2021-06-04. The home page appears, with objects you have specified as favorites in the Favorites panel (if any).
From the Manage menu, select Manage Data. The Manage Data page appears.
Select Administered Items Tool. The Administered Items Tool 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 Item Type Select a (TBD)the type of registered administered item. Latest Version? Select one of the following options: - To search for the latest version of an item, select Yes.
- To search for all versions except the latest version, select No.
As in all fields, the default behavior returns all versions
Specify whether the (TBD) (Yes) or not (No).
Long Name Type all or part of the (TBD)long name for an item. Public ID Specify the full numeric value for the (TBD).a single public ID. (You cannot use wildcards in numeric fields.) Short Name Type all or part of the (TBD)short name for an item. Owned By Select one or more (TBDs)contexts. Owning contexts have the privilege to edit and update an item. Registration Status Select one or more (TBDs)registration statuses. For details, refer to Registration Status. Workflow Status Select one or more (TBDs)workflow statuses. For details, refer to Workflow Status. Origin Select one or more (TBDssources (document, project, discipline, or model). Origin Description Type all or part of the (TBD)origin description an item. Created By Select the person who created an item. You can select one or more (TBDs)people. Last Modified By Select the person who last modified an 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.)
- (TBDs).
If necessary, you can specify additional criteria using a for finding items using one of the "Child Filter" options in the lower part of the search page. The system filters for items that match details specified in the selected child filter. For details, click one of the following links:
Expand title Specify Criteria for Additional Search Criteria Field Instructions TBD Multiple Public ID Search Enter a public ID, complete or partial.
To specify multiple public IDs, click the Advanced Filter icon. In the adjacent field, select One of the Words. Enclose each ID in periods and separate each value with a space (for example: .5. .6. .10.).
Enter Search String TBDType all or part of a search string. This field searches long name, short name, and definition. (To adjust search scope, click the Advanced Filter icon.)
HTML Comment hidden true To view a tooltip listing the fields searched, hover your mouse pointer over the field label.
Expand title Specify Criteria for Alternate Definitions Field Instructions Alternate Definition Type all or part of an alternate definition. (To adjust search scope, click the Advanced Filter icon.) Definition Type Select a definition type. Context Select one or more contexts. Language Select a language. TBD TBD Expand title Specify Criteria for Alternate Names Field Instructions Alternate Name An item may have multiple alternate names in multiple contexts. Type all or part of an alternate name. (To adjust search scope, click the Advanced Filter icon.) Alternate Name Type Select an alternate name type. Context Select one or more contexts. TBD TBD Expand title Specify Criteria for Associated Concepts Field Instructions TBD Primary Specify whether the associated concept is primary (Yes) or not (No). Concept Select one or more concepts. Concept Name Type all or part of a concept name. Concept Code Type all or part of a concept code. Integer Value Specify all or part of the integer value. You can specify part of the value because this field is actually a text field. For example, if you specify "20" in this field and if items exist with "120" or ">=200", the system returns those items. (To adjust search scope, click the Advanced Filter icon.)TBD Expand title Specify Criteria for Classifications Field Instructions TBD CS|CSI Select one or more classification schemes or classification scheme items. CS Long Name Type all or part of the long name for a classification scheme.TBD Expand title Specify Criteria for Owned By or Used By Context Field Instructions Context Select one or more contexts. TBD TBD Expand title Specify Criteria for Reference Documents Field Instructions Document Name Type all or part of a reference document name. (To adjust search scope, click the Advanced Filter icon.) Document Type Select a document type. Document Text Type all or part of a search string. This field searches reference document text. (To adjust search scope, click the Advanced Filter icon.) Context Select one or more contexts. TBD TBD Expand title Specify Criteria for CDE: DEC and VD Attributes Field Instructions TBD Data Element Concept Select one or more data element concepts. DEC Public ID Specify the full numeric value for a single data element concept public ID. (You cannot use wildcards in numeric fields.) DEC Long Name Type all or part of the long name for a data element concept. DEC Short Name Type all or part of the short name for a data element concept. Value Domain Select one or more value domains. VD Public ID Specify the full numeric value for a single value domain public ID. (You cannot use wildcards in numeric fields.) VD Long Name Type all or part of the long name for a value domain. VD Short Name Type all or part of the short name for a value domain. Preferred Question Text Type all or part of the preferred question text. (To adjust search scope, click the Advanced Filter icon.) Derived Data Element Specify whether the system derives the data element (Yes) or not (No).TBD Expand title Specify Criteria for Classification Scheme Item Attributes Field Instructions Classification Scheme Select one or more classification schemes. CSI Select one or more classification scheme items. TBD TBD Expand title Specify Criteria for Concept Attributes Field Instructions TBD Concept Select one or more concepts. Source Type Select a concept source type. Rep Term Primary Concept Specify whether the representation term is a primary concept (Yes) or not (No). TBD Expand title Specify Criteria for Conceptual Domain Attributes Field Instructions Conceptual Domain Select one or more conceptual domains. TBD TBD Expand title Specify Criteria for Data Element Concept Attributes Field Instructions Object Class Select one or more object classes. Property Select one or more properties. Conceptual Domain Select one or more conceptual domains. CD Long Name Type all or part of the long name for a conceptual domain. TBD TBD Expand title Specify Criteria for Module Attributes Field Instructions TBD Module Select one or more module names. Module Name Type all or part of a module name. (To adjust search scope, click the Advanced Filter icon.)TBD Expand title Specify Criteria for Protocol Attributes Field Instructions Protocol Select one or more protocols. This option is applicable only when searching for case report forms. Protocol Definition Type all or part of a protocol definition. Protocol Type Select a protocol type. Protocol ID Type all or part of a protocol ID. You can specify part of the value because this field is actually a text field. (To adjust search scope, click the Advanced Filter icon.) Protocol Phase Type all or part of a protocol phase. (To adjust search scope, click the Advanced Filter icon.) Lead Organization Select one or more organizations. TBD TBD Expand title Specify Criteria for Value Domain Attributes Field Instructions Value Domain Type Specify whether the value domain type is enumerated or not. caDSR Data Type Select a caDSR data type. Standard Data Type Select a standard data type. VD Minimum Length Specify the full numeric value for the minimum length of a value domain. (You cannot use wildcards in numeric fields.) VD Maximum Length Specify the full numeric value for the maximum length of a value domain. (You cannot use wildcards in numeric fields.) Unit of Measure Select a unit of measure. Format Select a format. Representation Term Select one or more representation terms. Representation Term Long Name Type all or part of the long name for a representation term. Conceptual Domain Select one or more conceptual domains. TBD TBD Expand title Specify Criteria for Value Meaning Attributes Field Instructions TBD Value Meaning Select one or more value meanings. VM Description Text Type all or part of value meaning description text. (To adjust search scope, click the Advanced Filter icon.)TBD HTML Comment hidden true Note to editors of this page: When searching in OneData, if child filter name starts with a number, a plus sign (+), or an asterisk (*), it's a valid filter. The child filter "Data Element Details" (in "Data Elements - View/Browse") is also a valid filter. None of the other filters are valid.
Click Apply Filter. The system lists all items that match your criteria. You can sort columns by clicking the column headers and selecting one of the choices: Ascending, Descending, Clear Sort, or New Sort.
...