[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.
Generated at Thu Mar 28 20:27:37 UTC 2024 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.