[CORE-294] Upgrade scripts: Add new SQL breakdowns to upgrade scripts for 1.7.10 Created: 31/Jan/18 Updated: 30/May/19 Resolved: 23/Apr/18 |
|
Status: | Resolved |
Project: | i2b2 Core Software |
Component/s: | Data |
Affects Version/s: | None |
Fix Version/s: | 1.7.10 |
Type: | Improvement | Priority: | Major |
Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
Resolution: | Done | Votes: | 0 |
Labels: | data, wikirelease | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Rank: | 0|hzzzyi: |
Affects Database/s: |
All databases
|
Participant/s: |
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 |
Comments |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add roles column to upgrade script |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add roles column to upgrade script |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add insert new data target |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add insert new data target |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add sql breakdowns |
Comment by Janice Donahoe [ 19/Apr/18 ] |
add sql breakdowns |
Comment by Janice Donahoe [ 23/Apr/18 ] |
The new SQL breakdowns have been added to the upgrade scripts for release 1.7.10. |