NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When you search for Common Data Elements (CDEs) 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 and gene 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 CDE 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 CDEs 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.
Excerpt
hiddentrue

Started drafting instructions.

...

To perform a data element search:

  1. Include Page
  2. Open a supported browser:
    • TBD
    • TBD
  3. Navigate to the following portal:

    https://wmonedata.nci.nih.gov/

    The home page appears. 

  4. browser and portal step include
    browser and portal step include
  5. From the View menu, select Browse and then select one of the following options:

    • Data Elements - View/Browse: Search for data elements used by or owned by any context. 
    • NCI Standard Data Elements: Search for within released data elements used that are either owned by or owned used by context NCI Standards only. the NCI Standards Context. NCI considers these data elements to be standard for the NCI. These elements are a subset of the data elements available in Data Elements- View/Browse.

    The corresponding page appears. (Logged in users can add pages like this to their favorites. For instructions, refer to Managing Your Favorites.)

  6. If necessary, you can clear the saved filter from the upper right corner of the search criteria panel, or select a different one:

    • The default saved filter excludes retired (from Workflow Status), excludes test and training (from Owned By), and includes the latest version. 
    • Another saved filter excludes only test and training (from Owned By).
    • Another saved filter includes only test and training (from Owned By).
    • To clear the saved filter, set this field to Select a Filter.
  7. Specify one or more search criteria, as described in the following table: 

    FieldInstructions
    Enter Search StringEnter Type all or part of a search string, complete or partial, separating multiple words with a space. The search is not case-sensitive. (TBD: If possible, I'd like to include here a list or description of the fields in which the system searches when the user specifies a search term here. This field searches the concatenation of CDE Short Name, CDE Long Name, and any type of Question text. (To adjust search scope, click the Advanced Filter icon.)
    CDE Public IDEnter a Specify the full numeric value for a single CDE public ID. (You cannot use wildcards in this fieldnumeric fields. )
    CDE Long NameEnter a Type all or part of a CDE long name, complete or partial, separating multiple words with a space. The search is not case-sensitive. . (To adjust search scope, click the Advanced Filter icon.)
    Multiple Public ID Search

    Enter a Type all or part of 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

    To treat each specified number as a complete ID, enclose each ID in periods and separate each value with a space (for example: .5. .6. .10.). (TBD: Considering the word "Multiple" in the field label, I'm surprised users have to take these extra steps.)The periods ensure an exact match to the public ID. Otherwise, this search treats the IDs as text and returns any public ID containing the specified value. For example, "5" returns any public ID containing "5". Also, if you have a column of IDs in a spreadsheet, and each ID is enclosed in periods, you can copy that column into this field.

    Multiple Public ID Search field with example IDs.Image Added

    CDE Short NameEnter Type all or part of a CDE short name, complete or partial.. (To adjust search scope, click the Advanced Filter icon.) 
    Latest VersionData elements are assigned version numbers by the context administratorcurators. As in all fields, the default behavior returns all versions. Select one of the following options:.
    • To search for the latest version of the CDE, select Yes.
    • To search for all versions except the latest version, select No.
    Owned BySpecify the context that has administrative authority Select one or more contexts. Owning contexts have the privilege to edit and update the CDE.
    Registration StatusRegistration status filters your results based on the data element registration status. Select one or more registration statuses.  For details, refer to (link TBD). Registration Status
    Workflow StatusWorkflow status filters your results based on the administrative workflow status of the data element. Select one or more workflow statuses.  In most cases, you will want to search for released "Released" data elements, but any status is available.  For For details, refer to (link TBD). Workflow Status
    OriginSpecify the Specify the source of the administered item. Select one or more sources.
    Origin DescriptionSpecify a search string for the origin description. (TBD: This field doesn't seem to work for me.) 
    Program AreaSelect a program area.one or more program areas.
    Created BySelect the person who created the item. You can select one or more people. 
    Last Modified BySelect the person who last modified the item. You can select one or more people. (To adjust search scope, click the Advanced Filter icon.)
  8. 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
  9. For date criteria, click the Audit Columns icon and specify dates as described in the following table: 

    FieldInstructions
    Date CreatedClick the calendar icon and select the date on which the item was created.
    Date Last ModifiedClick 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. 
  10. 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.)
  11. If necessary, you can specify additional criteria using a for finding data elements using one of the "Child Filter" options in the lower part of the search page. The system filters for data elements that match details specified in the selected child filter. For details, click one of the following links:

    Expand
    titleSpecify Criteria for Question Texts
    FieldInstructions
    Question TextTBDType all or part of the actual text that appears for the data element on a Form. (To adjust search scope, click the Advanced Filter icon.)
    Question TypeTBD

    Select a question type:

    • Alternate Question Text 
    • Application Standard Question Text 
    • CDASH Alternate Question Text 
    • NRDS Question Text 
    • Preferred Question Text 
    • Standard Alternate Question Text
    Question Text NameTBDType all or part of the question text name.
    ContextTBDSelect one or more contexts. 
    LanguageTBDSelect a language. 
    Enter Search StringTBDType all or part of a search string. This field searches Question Text and Question Text Name. (To adjust search scope, click the Advanced Filter icon.)
    Expand
    titleSpecify Criteria for Alternate Names
    FieldInstructions
    Alternate NameTBDA data element 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 TypeTBDSelect one or more alternate name types. (To adjust search scope, click the Advanced Filter icon.)
    ContextTBDSelect one or more contexts. 
    LanguageTBDSelect a language.
    Expand
    titleSpecify Criteria for Alternate Definitions
    FieldInstructions
    DefinitionTBDType all or part of the definition. (To adjust search scope, click the Advanced Filter icon.)
    Definition TypeTBDSelect a definition type.
    ContextTBDSelect one or more contexts. 
    LanguageTBDSelect a language.
    Expand
    titleSpecify Criteria for Associated Concepts
    FieldInstructions
    PrimaryTBDSpecify whether the associated concept is primary (Yes) or not (No). 
    ConceptTBDSelect one or more concepts. 
    Concept DefinitionTBDType all or part of the concept definition. 
    Integer ValueTBDSpecify 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.)
    Expand
    titleSpecify Criteria for Classifications
    FieldInstructions
    CS Long NameTBD
    CS Public IDTBD
    CSI Long NameTBD
    CS|CSITBD
    |CSISelect one or more classification schemes or classification scheme items.
    CS Context

    Type all or part of the classification scheme context. 

    HTML Comment
    hiddentrue

    Note to editors of this page: This field cannot be changed to a multi-select pop-up due to the way it is retrieved.

    CS Long NameType all or part of the classification scheme long name. (To adjust search scope, click the Advanced Filter icon.)
    Enter Search StringType all or part of a search string. This field searches CS Long Name and CSI Long Name. (To adjust search scope, click the Advanced Filter icon.)Enter Search StringTBD
    Expand
    titleSpecify Criteria for Permissible Values
    FieldInstructions
    Permissible ValueTBDEnter a permissible value to return a list of data elements based on or limited to that permissible value. (To adjust search scope, click the Advanced Filter icon.)
    Value MeaningTBDType all or part of a value meaning. (To adjust search scope, click the Advanced Filter icon.)
    Concept CodesTBDType all or part of a concept code. 
    VM DescriptionTBDType all or part of value meaning description. 
    PV Parent ConceptTBDSelect one or more permissible value parent concepts. 
    Enter Search StringTBDType all or part of a search string. This field searches VM Long Name or VM Description. (To adjust search scope, click the Advanced Filter icon.)
    Expand
    titleSpecify Criteria for VM Alternate Names
    FieldInstructions
    Permissible ValueTBDType all or part of a permissible value. 
    Value MeaningTBDType all or part of a value meaning.
    VM Alternate NameTBDType all or part of a value meaning alternate name. (To adjust search scope, click the Advanced Filter icon.)
    Name TypeTBDSelect one or more name types. 
    ContextType all or part of a context. (To adjust search scope, click the Advanced Filter icon.) (TBD: Most of the Context fields changed to a multi-select pop-up, but this one is still a text box. Will this Context field also change to a multi-select popup?)
    LanguageTBDSelect a language. 
    Expand
    titleSpecify Criteria for VM Alternate Definitions
    FieldInstructions
    Permissible ValueTBDType all or part of a permissible value. (To adjust search scope, click the Advanced Filter icon.)
    Value MeaningTBDType all or part of a value meaning. (To adjust search scope, click the Advanced Filter icon.)
    VM Public IDTBDSpecify the full numeric value for a single value meaning public ID. (You cannot use wildcards in numeric fields.)
    VM Alternate DefinitionTBDType all or part of a value meaning alternate definition. (To adjust search scope, click the Advanced Filter icon.)
    Definition TypeTBDSelect one or more definition types.
    ContextTBDSelect one or more contexts. 
    Expand
    titleSpecify Criteria for Forms/Modules
    FieldInstructions
    FormTBDSelect one or more forms. 
    Module NameTBDType all or part of a module name. (To adjust search scope, click the Advanced Filter icon.)
    Expand
    titleSpecify Criteria for Reference Documents
    FieldInstructions
    Document NameTBDType all or part of a reference document name. (To adjust search scope, click the Advanced Filter icon.)
    Document TypeTBDSelect one or more reference document types.
    Document TextTBDType all or part of a search string. This field searches reference document text. (To adjust search scope, click the Advanced Filter icon.)
    ContextTBDSelect one or more contexts.
    LanguageTBDSelect a language.
    Enter Search StringTBDType all or part of a search string. This field searches Document Name and Document Text. (To adjust search scope, click the Advanced Filter icon.)
    Expand
    titleSpecify Criteria for Derivation Components
    FieldInstructions
    Component CDETBDSelect one or more component CDEs.
    Component CDE Public IDTBDSpecify the full numeric value for a single component CDE public ID. (You cannot use wildcards in numeric fields.)

    (To view all derived data elements, select the Derivation Components child filter, leave all fields blank, and click Apply Filter.)

    Expand
    titleSpecify Criteria for Owned By or Used By

    This child filter is available only for Data Elements - View/Browse. 

    FieldInstructions
    Owned By or Used By ContextSelect one or more contexts. Data elements are owned by the context that has administrative authority to edit and update them. In addition to the owning context however, a data element can be designated for use by another non-owning context. ContextTBD
    Expand
    titleSpecify Criteria for Data Element Details
    TBD
    FieldInstructions
    DEC Long NameEnter a keyword to return CDEs with the specified data element concepts. (To adjust search scope, click the Advanced Filter icon.)
    DEC Public IDTBD
    VD Public IDTBD
    Derivation TypeTBD
    VD Maximum LengthTBD
    VD Minimum LengthTBD
    VD TypeTBD
    VD Display FormatTBD
    Unit of MeasureTBD
    Source Data TypeTBD
    Standard Data TypeTBD
    Object Class Long NameTBD
    Property Long NameTBD
    Object Class Concept CodesTBD
    Property Concept Codes
    Specify the full numeric value for a single data element concept public ID. (You cannot use wildcards in numeric fields.)
    VD Long NameType all or part of the value domain long name. (To adjust search scope, click the Advanced Filter icon.)
    VD Public IDSpecify the full numeric value for a single value domain public ID. (You cannot use wildcards in numeric fields.)
    Derived DESpecify whether the data element is derived (Yes) or not (No).
    Derivation TypeSelect a derivation type.
    VD Maximum LengthSpecify the full numeric value for the maximum length of a value domain. (You cannot use wildcards in numeric fields. To adjust search scope, click the Advanced Filter icon.)
    VD Minimum LengthSpecify the full numeric value for the minimum length of a value domain. (You cannot use wildcards in numeric fields. To adjust search scope, click the Advanced Filter icon.)
    VD TypeSpecify whether to search for an Enumerated or Non-Enumerated value domain. To search for both, clear this field. (That is, set it to Select a Value.)  
    VD Display FormatSelect a value domain display format. 
    Unit of MeasureSelect a unit of measure.
    Source Data TypeSelect a source data type.
    Standard Data TypeSelect a standard data type.
    Object Class Long NameEnter a keyword to return CDEs with the specified object class name. (To adjust search scope, click the Advanced Filter icon.)
    Property Long NameEnter a keyword to return CDEs with the specified property name. (To adjust search scope, click the Advanced Filter icon.)
    Object Class Concept CodesType all or part of the object class concept code.
    Property Concept CodesType all or part of the property concept code.
    HTML Comment
    hiddentrue

    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. 

  12. Click Apply Filter. The system displays the search results. By default, the system also hides the search criteria.

...