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

          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.10 [ 10307 ]
          jmd86 Janice Donahoe made changes -
          Summary Upgrade scripts: New SQL breakdowns missing from upgrade scripts Upgrade scripts: Add new SQL breakdowns to upgrade scripts for 1.7.10
          jmd86 Janice Donahoe made changes -
          Description The new SQL breakdowns are missing from the upgrade scripts. There are a total of 4 new breakdowns that are added to the QT_BREAKDOWN_PATH and QT_RESULT_TYPE tables.

          The 4 missing breakdowns are:

          PATIENT_LOS_XML
          PATIENT_TOP50MEDS_XML
          PATIENT_TOP50DIAG_XML
          PATIENT_INOUT_XML


          These breakdowns need to be added to the upgrade scripts for Oracle, PostgreSQL, and SQL Server.
          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_TOP50MEDS_XML
          PATIENT_TOP50DIAG_XML
          PATIENT_INOUT_XML
          jmd86 Janice Donahoe made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          mem61 Mike Mendis made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Janice Donahoe [ jmd86 ]
          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 -
          Rank Ranked higher
          jmd86 Janice Donahoe made changes -
          Sprint v1710.3 [ 25 ]
          jmd86 Janice Donahoe made changes -
          Rank Ranked higher
          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
          jmd86 Janice Donahoe made changes -
          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_TOP50MEDS_XML
          PATIENT_TOP50DIAG_XML
          PATIENT_INOUT_XML
          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
          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.
          jmd86 Janice Donahoe made changes -
          Resolution Done [ 10001 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Labels data wikirelease
          jklann Jeffrey Klann made changes -
          Sprint
          jklann Jeffrey Klann made changes -
          Rank Ranked higher

          People

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

            Dates

              Created:
              Updated:
              Resolved: