Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-264

OMOP Data Scripts - valueflag_cd is misspelled in the create_omop_views.sql

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.09-RC1
    • 1.7.09
    • Data
    • None
    • Oracle
    • Fixed the column name in the create_omop_views.sql script to accurately spell the 'valueflag_cd' column (measurement_view).
    • The oracle scripts were updated and the change appears to be working correctly.

    Description

      The create_omop_views.sql script for oracle has a misspelling in one of the column names. The 'valueflag_cd' column in the measurement_view is spelled 'valueflage_cd'. This misspelling is causing a problem when rendering a timeline in the i2b2 Web Client as the column cannot be found.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Fix Version/s 1.7.09 [ 10306 ]
          jmd86 Janice Donahoe made changes -
          Affects Version/s 1.7.09-RC1 [ 10702 ]
          jmd86 Janice Donahoe made changes -
          Assignee Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Developer Notes Fixed the column name in the create_omop_views.sql script to accurately spell the 'valueflag_cd' column (measurement_view).
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes The oracle scripts were updated and the change appears to be working correctly.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: