NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

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

Started drafting instructions.

When you search for Common 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 (you can specify with options such as IS NULL, IS NOT NULL, NOT LIKE, Exact Phrase Match,  All All Of The Words, or One Of The Words) by clicking the Advanced Filter icon. 
  • In any editable text fields, you can use a percent sign (%) as a wildcard. For examples, refer to Using Wildcards - 2021-06-09
  • The system processes search criteria as AND statements, so the results include only CDEs that fulfill all the criteria are returned.
  • 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:

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

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

    The home page appears. 

  4. 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 within released data elements that are either owned by or used by the NCI Standards Context. This menu option is a shortcut to find all the data elements that NCI has deemed to be a 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.)

  5. 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.
  6. Specify one or more search criteria, as described in the following table: 

    DateTBD
    FieldInstructions
    Enter Search StringEnter Type all or part of a search string, complete or partial. 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. 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.) (TBD: Finish copying this parenthetical about Advanced Filter to all relevant rows.) 
    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.
    • To search for all versions, clear this field. (That is, set it to Select Value.) 
    Owned BySelect one or more contexts. Owning contexts have the privilege Owned BySpecify the context that has administrative authority 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 one or more program areaareas.
    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.)
  7. 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. 
  8. 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. 
  9. 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.)
  10. 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 TextType 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 Type

    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
    TBDQuestion TypeTBD
    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 NameA data element may have multiple alternate names in multiple contexts. Enter Type all or part of an alternate name or keyword, and then specify an Alternate Name Type. (To adjust search scope, click the Advanced Filter icon.)
    Alternate Name Type(TBD: The CDE Browser User Guide said a type is required if you specify an alternate name, but that doesn't seem to be true in OneData.) You can select multiple items in the list. (TBD: This statement is true for several fields. Say it once at the top, or repeat it for each field?)
    ContextTBD
    Select one or more alternate name types. (To adjust search scope, click the Advanced Filter icon.)
    ContextSelect one or more contexts. 
    LanguageSelect a language.LanguageTBD
    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|CSITBDSelect one or more classification schemes or classification scheme items.
    CS ContextTBD

    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 NameTBDType all or part of the classification scheme long name. (To adjust search scope, click the Advanced Filter icon.)
    Enter Search StringTBDType 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.)
    Expand
    titleSpecify Criteria for Permissible Values
    FieldInstructions
    Permissible ValueEnter 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. 

    TBD
    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. Selecting a particular Context Use allows you to return only data elements that are Used, Owned, or Owned By/Used By the current context. Owned By/Used By is the default setting. (TBD: This text came from the CDE Browser User Guide, but it doesn't make sense with the fields in the Used By child filter. I need help understanding these fields.)Owner Context? 
    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 IDTBDSpecify the full numeric value for a single data element concept public ID. (You cannot use wildcards in numeric fields.)
    VD Long NameTBDType all or part of the value domain long name. (To adjust search scope, click the Advanced Filter icon.)
    VD Public IDTBDSpecify 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 TypeTBDSelect a derivation type.
    VD Maximum LengthTBDSpecify 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 LengthTBDSpecify 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 FormatTBDSelect a value domain display format. 
    Unit of MeasureTBDSelect a unit of measure.
    Source Data TypeTBDSelect a source data type.
    Standard Data TypeTBDSelect 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 CodesTBDType all or part of the object class concept code.
    Property Concept CodesTBDType 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. 

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

...