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

Upgrade scripts: Add new SQL breakdowns to upgrade scripts for 1.7.10

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Done
    • None
    • 1.7.10
    • Data
    • All databases

    Description

      A new feature has been added to version 1.7.10 that allows SQL queries to be added to the breakdowns. As part of the release we have provided examples of how users can implement this new feature. The examples have been added to the new install scripts and now need to be added to the upgrade scripts for Oracle, PostgreSQL, and SQL Server. The following 4 breakdowns need to be added to the QT_BREAKDOWN_PATH and QT_RESULT_TYPE tables.

      PATIENT_LOS_XML
      PATIENT_TOP20MEDS_XML
      PATIENT_TOP20DIAG_XML
      PATIENT_INOUT_XML

      Attachments

        Activity

          add roles column to upgrade script
          jmd86 Janice Donahoe added a comment - add roles column to upgrade script
          add roles column to upgrade script
          jmd86 Janice Donahoe added a comment - add roles column to upgrade script
          add insert new data target
          jmd86 Janice Donahoe added a comment - add insert new data target
          add insert new data target
          jmd86 Janice Donahoe added a comment - add insert new data target
          add sql breakdowns
          jmd86 Janice Donahoe added a comment - add sql breakdowns
          add sql breakdowns
          jmd86 Janice Donahoe added a comment - add sql breakdowns
          The new SQL breakdowns have been added to the upgrade scripts for release 1.7.10.
          jmd86 Janice Donahoe added a comment - The new SQL breakdowns have been added to the upgrade scripts for release 1.7.10.

          People

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

            Dates

              Created:
              Updated:
              Resolved: