Changes between Version 18 and Version 19 of LEGACY - i2b2OntologyCRC-1


Ignore:
Timestamp:
02/22/11 14:00:16 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2OntologyCRC-1

    v18 v19  
    3232   * select count(*) from observation_fact where valtype_cd like '%N%' ===> returns 23731
    3333
     34----
     35Experiment conducted (Jeff):[[br]]
     36Went into the database and chose to update a column in the Onyx metadata table for the Briccs project...[[BR]]
     37update onyx set c_COLUMNDATATYPE = 'N' where c_name = 'history_AF_onset' ; [[br]]
     38Went into the workbench and refreshed the ontology tree. Dragged the history_AF_onset leaf into a group. [[br]]
     39It would not allow me to set a value ('Set value...' was greyed out / disabled). [[br]]
     40Being neurotic, I then tried: [[br]]
     41update onyx set c_operator = '=' where c_name = 'history_AF_onset' [[br]]
     42Restarted the workbench just to be sure. No change![[br]]
     43
     44If you want to set a value for a term in a query, you obviously need to do more than this.
     45----
     46
    3447=== Facts constrained by enumerated concepts ===
    3548Facts can be constrained by simply pointing at a concept row within the concept_dimension table with very little else alongside it. For example, a numeric value like AGE can be divided into an enumeration of concepts, say one for each age from 0 to 114, as is the demo system. Here is a selection based upon this: