Downloads:
Relevant Documentation:
|
i2b2 1.8.2-beta Release introduces functionality of user-created data table definition and data download of limited data sets (LDS). The Data Request Management tool enables project managers to manage the data file exports. In addition, there are minor improvements in the Query tool, improvements to the fast "totalnum" patient counting scripts, and some bug fixes.
| Description | ||
|---|---|---|
| Create data table for Export Extension for i2b2 |
| The Create Data Table tool allows the i2b2 user to create their own data table definitions with ontology variables and then request data exports in the Run Query dialog. |
| Data Request Manager Extension for i2b2 |
| The Data Request Manager tool allows an i2b2 manager to manage and process the user data requests. NOTE: In this beta release, clicking Create File on a custom-table data request in a Postgres database does not actually generate the file. |
| Enhanced Data Exporter (v1.8.1) |
| v1.8.1-style data exports (pre-defined tables defined by domain) can now be run and managed using the new tools. Manager users can manage and generate these data file exports using the Data Request Manager Console |
UI Query tool improvements | The new webclient has minor updates to improve the user experience | |
| Digital Twin Bundle (distributed separately) |
| Tools for computing loyalty cohorts and computational phenotypes in i2b2. |
Bug fixes |
|
i2b2 data exporter functionality is now enhanced the enable i2b2 users to create their own Data table definitions from ontology elements. The data table definitions are displayed as options that can be selected in the Run Query dialog. Users can submit multiple data requests for with a query. The Manager user can manage the data requests and generate data files using a Data Request Manager console. Detailed documentation on set up can be found here: Data Exporter Set-up
The below steps describe the overall process:
The JDBC drivers were updated to the following versions.
Server Type | oracle | Postgresql | mssql |
|---|---|---|---|
Driver Version | ojdbc8.jar | postgresql-42.7.1.jar | mssql-jdbc-12.4.2.jre8.jar |
Server Type | SQL Server | Oracle | PostgresSQL |
|---|---|---|---|
Supported Version/s | 2012+ (tested with up to 2022) | 23.3 | 9 to 14 |
Application Type | Java | Wildfly | Apache HTD | Apache Ant | Apache Axis2 | PHP |
|---|---|---|---|---|---|---|
Supported Version/s | 17 | 34 | 2.0 (RHEL 6) and 2.2 ( RHEL 7) | 1.9.6 | 2 | 7.2.27 or higher |
Rocky linux 8 and 9, CentOS versions 7
Windows 2016 -2019
Unofficially, MacOS and other flavors of Linux are likely to work.
| Web client |
|---|
WEBCLIENT-368 1.8.2 Webclient update |
| Core-server |
CORE-456 Data Export: agg table CORE-455 Data Export: Request Management admin tool CORE-451 Enhanced Data Export - download file generation CORE-459 updrade to wildfly 34 with axis2 version2 CORE-460 Upgrade to JAVA 17 CORE-454 Upgrade Spring jar to version 6 CORE-447 Update JDBC drivers CORE-458 Software maintainence - drivers, libraries CORE-445 java code folder structure for 1.7 should be changed to refer to 1.8.2 |
| Core-server / Data | |
|---|---|
CORE-450 html injection in Queryname and workplace CORE-249 Search by code fails ungracefully |
If you change the xsd (REST API message definitions), then you will need to regenerate gensrc via JAXB in Java 8. In the i2b2-core cell directory for which you're regenerating the XSD-Java, run the ant target "jaxb_gen" on Java 8 and then build as usual using Java 17.
In this beta release, clicking Create File on a custom-table data request in a Postgres database does not actually generate the file.
.svg.med.png)