Page History
html-text |
---|
<!DOCTYPE html> <html> <head> <title>i2b2 1.7.10 Release Notes</title> <meta charset="UTF-8"> <meta name="description" content="The release notes for version 1.7.10 of the i2b2 Software" /> <meta name="keywords" content="i2b2, release, 1.7, 1.7.03, 1.7.03a, 1.7.04. 1.7.05, 1.7.06, 1.7.07, 1.7.07b, 1.7.08, 1.7.08a, 1.7.09, 1.7.09a, 1.7.09b, 1.7.09c, 1.7.10" /> <link rel="stylesheet" type="text/css" media="all" href="/stylesheets/i2b2-wiki.css" /> </head> <body> <h1 id="rel1710">i2b2 Release 1.7.10</h1> <p class="releaseDate"><b>Release Date:</b> April 27, 2018</p> <h2 id="rel1710Summary">1.7.10 Release Summary</h2> <p> Release 1.7.10 contains many new enhancements to the i2b2 kernel, many of which improve the security around signing into the i2b2 Web Client. We have included some Auditing features like logging all successful and attempted logins into the i2b2 Web Client or keeping a log of all the Admin functions performed with the Admin Module. The </p> <p> Some other improvements include some minor bug fixes to the i2b2 Web Client</p> <ul> <li>Cosmetic issues with the way information is displayed in the Web Client</li> <li>New icons for the Wise plugin</li> <li>Fix for possible null pointer when cancelling a query</li> </ul> <br> <p> </p> <h2 id="rel1710installNotes">Installation Notes</h2> <ul> <li> This release note applies to you if you are <b>upgrading</b> your i2b2 <b>to 1.7.10</b> <b><i>from</i></b> an <b><i>earlier 1.7.x version</i></b> of the i2b2 software. </li> <li> If you are installing a new instance of i2b2 we recommend you refer to the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">installation documentation</a> found on the <a href="https://community.i2b2.org/wiki">i2b2 community wiki</a>. This documentation will guide you through the entire installation process. </li> </ul> <!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version --> <!-- <h2 id="rel1709cshrineApprvl">SHRINE Approval</h2> <p class="shrineApprvTxt"> <img class="shrineApprvlImg" src="https://community.i2b2.org/wiki/download/attachments/15729710/shrineApprvl_v1-22-08.png" width="57" height="57" alt="Shrine Approval"><i>SHRINE Release 1.22.8</i> has been tested with <i>i2b2 1.7.09c Release</i> and has been <b>approved</b> by the SHRINE Team</p> --> <h2 id="rel1710upgradeNotes">Upgrade Notes</h2> <p>This release does not include changes to The changes included in this release do not require any changes made to other i2b2 software components like the i2b2 server or database scripts.</p> <p> i2b2 Release 1.7.10 contains changes to the following i2b2 software components: </p> <ul> <li>Database Scripts</li> <li>i2b2 Server (core software)</li> <li>i2b2 Web Client</li> </ul> <h2 id="rel1710chgSumCore">Change Summary - i2b2 Kernel (Core Software) - Release 1.7.10</h2> <h3>New Features</h3> <ul> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-160">CORE-160</a>] - Include full release number somewhere in hive installation </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-290">CORE-290</a>] - New Breakdowns based on SQL Query </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-285">CORE-285</a>] - Log number of attempted logins </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-286">CORE-286</a>] - Log admin functions </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-287">CORE-287</a>] - Lockout after failed logins </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-288">CORE-288</a>] - Enforce complex passwords </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-289">CORE-289</a>] - Mandatory password change </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-300">CORE-300</a>] - Do not allow current password to be used as new password </li> </ul> <h3>Improvements</h3> <ul> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-129">CORE-129</a>] - Improve datasource validations </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-294">CORE-294</a>] - Upgrade scripts: Add new SQL breakdowns to upgrade scripts for 1.7.10 </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-304">CORE-304</a>] - Database: Remove primary key & add index to PM_USER_LOGIN </li> </ul> <h3>Bug Fixes</h3> <ul> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-272">CORE-272</a>] - Unable to run breakdown queries due to casting error </li> <li>[<a href="http://community.i2b2.org/jira/browse/CORE-284">CORE-284</a>] - Ant not working with Oracle 12 JDBC driver ojdbc7.jar </li> </ul> <!-- #NOTE: WEB CLIENT SECTION --> <h2 id="rel1710chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.10</h2> <h3>New Features</h3> <ul> <li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-226">WEBCLIENT-226</a>] - Single sign-on location for Web Client and Admin </li> <li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-237">WEBCLIENT-237</a>] - New Simple Temporal Query mode </li> </ul> <!-- <h3>Improvements</h3> <ul> <li></li> </ul> --> <h3>Bug Fixes</h3> <ul> <li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-194">WEBCLIENT-194</a>] - Cancel button on new DBLookup pages does not work </li> <li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-227">WEBCLIENT-227</a>] - Webclient Query Issues with Chrome and Safari </li> <li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-230">WEBCLIENT-230</a>] - Date constraint window doesn't close if table name is undefined </li> </ul> <!-- <h2 id="rel1710newFeatureDetails">New Features & Improvements Details</h2> <h3 id="rel1710newFeatureDetails-logImprovements">Logging Improvements</h3> --> </body> </html> |
html-text |
---|
<!DOCTYPE html>
<html>
<head>
<title>i2b2 1.7.09c Release Notes</title>
<meta charset="UTF-8">
<meta name="description" content="The release notes for version 1.7.09c of the i2b2 Software" />
<meta name="keywords" content="i2b2, release, 1.7, 1.7.03, 1.7.03a, 1.7.04. 1.7.05, 1.7.06, 1.7.07, 1.7.07b, 1.7.08, 1.7.08a, 1.7.09, 1.7.09a, 1.7.09b, 1.7.09c" />
<link rel="stylesheet" type="text/css" media="all" href="/stylesheets/i2b2-wiki.css" />
</head>
<body>
<h1 id="rel1709c">i2b2 Release 1.7.09c</h1>
<p class="releaseDate"><b>Release Date:</b> January 12, 2018</p>
<h2 id="rel1709cSummary">1.7.09c Release Summary</h2>
<p>
Release 1.7.09c is a small release, however if you are a SHRINE user it does contain at least two important fixes that are necessary for you to run SHRINE queries without any issues.
</p>
<ul>
<li>Date constraints on SHRINE queries are not save on the local i2b2 side. This causes a problem when users re-run the query as they will receive different results because the constraint no longer exists.</li>
<li>Error would be returned if a query was still running when a user tried to view it in Previous Queries</li>
</ul>
<p>
Some other improvements include some minor bug fixes to the i2b2 Web Client
</p>
<ul>
<li>Cosmetic issues with the way information is displayed in the Web Client</li>
<li>New icons for the Wise plugin</li>
<li>Fix for possible null pointer when cancelling a query</li>
</ul>
<br>
<p>
</p>
<h2 id="rel2001installNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading your i2b2 server and Web Client to 1.7.09c</b> from an earlier version of the i2b2 software.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">installation documentation</a> found on the <a href="https://community.i2b2.org/wiki">i2b2 community wiki</a>. This documentation will guide you through the entire installation process. <a href="https://community.i2b2.org/wiki/display/getstarted/Chapter+8.+i2b2+Workbench+Install">Chapter 8. i2b2 Workbench Install</a> contains the information that is pertinent to the i2b2 workbench releases.
</li>
</ul>
<h2 id="rel1709cshrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="https://community.i2b2.org/wiki/download/attachments/15729710/shrineApprvl_v1-22-08.png" width="57" height="57" alt="Shrine Approval"><i>SHRINE Release 1.22.8</i> has been tested with <i>i2b2 1.7.09c Release</i> and has been <b>approved</b> by the SHRINE Team</p>
<h2 id="rel2001upgradeNotes">Upgrade Notes</h2>
<p>This release does not include changes to The changes included in this release do not require any changes made to other i2b2 software components like the i2b2 server or database scripts.</p>
<p>
i2b2 Release 1.7.09c contains changes to the following i2b2 software components:
</p>
<ul>
<li>i2b2 Server (core software)</li>
<li>i2b2 Web Client</li>
</ul>
<!--
<ul>
<li>Database Scripts</li>
<li>i2b2 Server (core software)</li>
<li>i2b2 Web Client</li>
</ul>
-->
<h2 id="rel1709cchgSumCore">Change Summary - i2b2 Core Software - Release 1.7.09c</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-235">CORE-235</a>] - Previous query panel - find terms by patient number is returning incorrect results
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-273">CORE-273</a>] - SHRINEACT queries with date constraints are losing the constraints on i2b2ACT side
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-276">CORE-276</a>] - get Query result instance id not found error on a running query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-279">CORE-279</a>] - Single panel exclusion query returns error
</li>
</ul>
<!-- #NOTE: WEB CLIENT SECTION -->
<h2 id="rel1709cchgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.09c</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-217">WEBCLIENT-217</a>] - Integers & fractional numbers can be entered for Max Time to Wait in Query Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-218">WEBCLIENT-218</a>] - Create new icons for the Wise plugin
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-219">WEBCLIENT-219</a>] - Update text in alert message that appears when running a query without a name
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-220">WEBCLIENT-220</a>] - Web Client possible null pointer
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-221">WEBCLIENT-221</a>] - Fix three cosmetic issues with way information displays in Web Client
</li>
</ul>
<h3>Tasks</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-222">WEBCLIENT-222</a>] - Include new file for value box improvements
</li>
</ul>
<h1 id="rel1709b">i2b2 Release 1.7.09b</h1>
<p class="releaseDate"><b>Release Date:</b> August 22, 2017</p>
<h2 id="rel1709bSummary">1.7.09b Release Summary</h2>
<p>
Release 1.7.09b fixes a problem where some users were not able to log into the i2b2 Admin module after installing version 1.7.09a. The logon problem only affected those users who downloaded the zip file from the i2b2 Software page. Users who downloaded the code directly from the i2b2 repositories do not have the issue.
</p>
<p>
The reason it only affects the zip file from i2b2.org/software is because we repackage the zip file from the i2b2-core-src repository to include the Admin module. When we add the Admin folder to the i2b2core-src-xxxx.zip file we have to modify some of the configurations. During this process one of the files was inadvertently updated using the wrong syntax to comment out some of the code. Release 1.7.09b fixes this problem with configuration file.
</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>
<br>
<b><i>This release does not contain any changes to the standard i2b2 code.</i></b> It is simply a modification to a configuration file that fixes a problem with not being able to log in to the Admin module.
<br>
<br>If you downloaded 1.7.09a directly from the i2b2 repositories on gitHub then you do not have the issue with the configuration file and therefore you do not need to update your i2b2 with Release 1.7.09b
</td>
</tr>
</tbody>
</table>
</div>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>
<br>The i2b2 JIRA issue (<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-216">WEBCLIENT-216</a>) contains detailed information on the issue and the resolution. Attached to the JIRA issue is a document that outlines how to manually fix the file (only necessary if you don't want to download and install 1.7.08b).
<br>
<br>Additional information on how to install the Admin on your i2b2 Server can be found in the <a href="i2b2-webclient/INSTALL-README.md">INSTALL-README.md</a> file located in the i2b2-webclient repository.
</td>
</tr>
</tbody>
</table>
</div>
<br>
<p>The bug fix (JIRA issue) included in this release can be found in the <a href="#rel1709bchgSumWebClient">Change Summary - i2b2 Web Client Software</a> section.</p>
<h2 id="rel1709binstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you installed 1.7.09a and are not able to log into the i2b2 Admin module.
</li>
<li>
If you are installing 1.7.09b from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">installation documentation</a> found on the <a href="https://community.i2b2.org/wiki">i2b2 community wiki</a>. This documentation will guide you through the entire installation process.
</li>
</ul>
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<!--
<h2 id="rel1709bshrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.09b Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<h2 id="rel1709bupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.09b does not contain code changes to any of the i2b2 software components. The release contains a fix to how a configuration file was packaged up wit the i2b2 Software.
</p>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1709bchgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.09b</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-216">WEBCLIENT-216</a>] - Some users are not able to log into the Admin Module
</li>
</ul>
<br>
<hr>
<h1 id="rel1709a">i2b2 Release 1.7.09a</h1>
<p class="releaseDate"><b>Release Date:</b> July 20, 2017</p>
<h2 id="rel1709aSummary">1.7.09a Release Summary</h2>
<p>
Version 1.7.09 of the i2b2 Software was incomplete when released. This resulted in errors being returned when compiling the Ontology Cell. Release 1.7.09a is the completed version of 1.7.09.
</p>
<p>The bug fix (JIRA issue) included in this release can be found in the <a href="#rel1709achgSumCore">Change Summary - i2b2 Core Software</a> section.</p>
<h2 id="rel1709ainstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.09a</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.09a from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">installation documentation</a> found on the <a href="https://community.i2b2.org/wiki">i2b2 community wiki</a>. This documentation will guide you through the entire installation process.
</li>
</ul>
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<!--
<h2 id="rel1709ashrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.09a Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<h2 id="rel1709aupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.09a contains changes to the following software components:
</p>
<ul>
<li>i2b2 Server (core software)</li>
</ul>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1709achgSumCore">Change Summary - i2b2 Core Software - Release 1.7.09a</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-268">CORE-268</a>] - Ontology cell fails to build when installing 1.7.09
</li>
</ul>
<br>
<hr>
<h1 id="rel1709">i2b2 Release 1.7.09</h1>
<p class="releaseDate"><b>Release Date:</b> June 16, 2017</p>
<h2 id="rel1709Highlight">1.7.09 Release Highlights</h2>
<ul>
<li>Querying multiple observation fact tables</li>
<li>Support for the OMOP Common Data Model (CDM)</li>
<li>Minor bug fixes - see release notes for details</li>
</ul>
<h2 id="rel1709Summary">1.7.09 Release Summary</h2>
<p>The standard i2b2 star schema only allows for one fact table, the observation_fact table. We have heard from the community there is a need to be able to search multiple fact tables with a single query. In release 1.7.09, the i2b2 has been updated to accommodate this growing need.</p>
<p>This new feature enables the i2b2 to adapt to the needs of the Patient Centered Outcome Research Institute (PCORI) network. It also supports the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM).</p>
<p>The i2b2 Community Wiki has additional information about multi-fact tables and i2b2 on OMOP. The following links will take you to their respective space on the wiki.</p>
<ul>
<li><a href="https://community.i2b2.org/wiki/display/MFT/Multi-fact+Table+Home">Multi-fact table documentation</a>
</li>
<li><a href="https://community.i2b2.org/wiki/display/OMOP/OMOP+Home">i2b2 on OMOP project</a>
</li>
</ul>
<br>
<p>A complete list of all the bug fixes and new features can be found in the Change Summary sections.</p>
<ul>
<li><a href="#rel1709chgSumCore">Change Summary - i2b2 Core Software</a>
</li>
<li><a href="#rel1709chgSumWebClient">Change Summary - i2b2 Web Client Software</a>
</li>
</ul>
<h2 id="rel1709installNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.09</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.09 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">installation documentation</a> found on the <a href="https://community.i2b2.org/wiki">i2b2 community wiki</a>. This documentation will guide you through the entire installation process.
</li>
</ul>
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<!--
<h2 id="rel1709shrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.09 Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<h2 id="rel1709upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.09 contains changes to the following software components:
</p>
<ul>
<li>i2b2 Data</li>
<li>i2b2 Server (core software)</li>
<li>i2b2 Web Client</li>
</ul>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1709chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.09</h2>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-240">CORE-240</a>] - Run queries using derived fact tables (Multi-fact table & OMOP)</li>
</ul>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-262">CORE-262</a>] - Clean up connection handling
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-228">CORE-228</a>] - Exception when running parallel queries using Postgres
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-237">CORE-237</a>] - Cant build timeline when db is postgres
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-246">CORE-246</a>] - Entries being written to the PM user session log at the same time will cause a query to error
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-247">CORE-247</a>] - PDO requests with empty filter list not working
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-252">CORE-252</a>] - Remove hard-coded timeout setting for medium and large queues
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-253">CORE-253</a>] - Multiple queues are created on startup
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-254">CORE-254</a>] - Queue startup needs to flush any previously running queues
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-256">CORE-256</a>] - OMOP Temporal queries with Excluded concepts dont work
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-257">CORE-257</a>] - Remove "dbo" from the ICD9-ICD10 install scripts (SQL Server)
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-258">CORE-258</a>] - OMOP: Error returned when trying to view details of an item on the timeline
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-263">CORE-263</a>] - PostgreSQL Error: Too many parameters specified for RAISE
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-264">CORE-264</a>] - OMOP Data Scripts - valueflag_cd is misspelled in the create_omop_views.sql
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-265">CORE-265</a>] - OMOP Data Views: Need to add a view for the Provider table
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-266">CORE-266</a>] - When multi-fact property not found, an ERROR is logged; should be INFO
</li>
</ul>
<!-- #NOTE: WEB CLIENT SECTION -->
<h2 id="rel1709chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.09</h2>
<h3>New Feature</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-206">WEBCLIENT-206</a>] - Custom Value Chooser Handling
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-154">WEBCLIENT-154</a>] - upon temporal query event selection, not able to drag and drop concept into anchoring observation if there are more than 3 grouppanels
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-207">WEBCLIENT-207</a>] - Max queries allows values <=0
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-210">WEBCLIENT-210</a>] - Cancelling the first query of a session causes error
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-211">WEBCLIENT-211</a>] - Query cancel causes prior query to be deleted
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-212">WEBCLIENT-212</a>] - PHP proxy does not support ports in automatic detection
</li>
</ul>
<h2 id="rel1709newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1709newFeatureDetails-multiFact">Multi-fact tables</h3>
<p>As stated earlier the standard i2b2 star schema only allows for one fact table, however [<a href="http://community.i2b2.org/jira/browse/CORE-240">CORE-240</a>] enables the crc to query multiple fact tables.</p>
<p>The setup is fairly simple; In the crc.properties file you will find a new parameter called <b>queryprocessor.multifacttable</b>, and when this parameter is set to <i>true</i> the crc will query all the fact tables you have setup.</p>
<p>The parameter is delivered with the value set to <i>false</i>, which means the multi-fact table feature is turned off and the CRC will behave as it has always done (prior to this release).</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>This same parameter is used by the <b>i2b2 on OMOP</b> project. For more information on this project please see the <a href="https://community.i2b2.org/wiki/display/OMOP/OMOP+Home">i2b2 on OMOP project space</a> on the <a href="https://community.i2b2.org/wiki">i2b2 Community Wiki</a>.
</td>
</tr>
</tbody>
</table>
</div>
<h3 id="rel1709newFeatureDetails-customValueHandling">Custom Value Choosing Handling</h3>
<p>We are working on re-developing the way the lab value chooser works in the web client. The new implementation will allow for custom lab value handling in a modularized way. <a href="http://community.i2b2.org/jira/browse/WEBCLIENT-206">WEBCLIENT-206</a> is laying the ground work for this re-design. Users will not notice a difference on how they select lab values.</p>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>We are working on re-developing the way the lab value chooser works in the web client. The new implementation will allow for custom lab value handling in a modularized way. WEBCLIENT-206 is laying the ground work for this re-design. Users will not notice a difference on how they select lab values.
</td>
</tr>
</tbody>
</table>
</div>
<br>
<hr>
<h1 id="rel1708b">i2b2 Release 1.7.08b</h1>
<p class="releaseDate"><b>Release Date:</b> December 13, 2016</p>
<h2 id="rel1708bSummary">1.7.08b Release Summary</h2>
<p>Release 1.7.08b fixes a bug in the CRC regarding when a query finishes running the BATCH_MODE in the QT_QUERY_INSTANCE table says PROCESSING INSTEAD OF FINISHED.
</p>
<h2 id="rel1708binstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.08b</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.08b from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<!--
<h2 id="rel1708bshrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.08b Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<h2 id="rel1708bupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.08b contains changes to the following software components:
</p>
<ul>
<li>i2b2 Server</li>
</ul>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1708bchgSumCore">Change Summary - i2b2 Core Software - Release 1.7.08b</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-245">CORE-245</a>] -BATCH_MODE says PROCESSING even though query finished running
</li>
</ul>
<br>
<hr>
<h1 id="rel1708a">i2b2 Release 1.7.08a</h1>
<p class="releaseDate"><b>Release Date:</b> November 23, 2016</p>
<h2 id="rel1708aSummary">1.7.08a Release Summary</h2>
<p>Release 1.7.08a is primarily focused on fixing and improving the queueing process. The main issue addressed in this release is a fix for an issue that was introduced in 1.7.08; An error was returned when a query timed out and moved on to the medium queue. Although the query continued to run it was misleading to users as they were informed it generated an error an was therefore no longer running. A number of other issues were uncovered during the development and testing of this release. A complete list of each issue can be found in the section titled <a href="#rel1708achgSumCore">Change Summary - i2b2 Core Software</a>
</p>
<!-- Add the following section once SHRINE approves this release; may need to update the SHRINE version -->
<!--
<h2 id="rel1708ashrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.08a Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<h2 id="rel1708ainstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.08a</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.08a from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1708aupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.08a contains changes to the following software components:
</p>
<ul>
<li>i2b2 Server</li>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>The changes to the queueing process were thoroughly tested against an Oracle and SQL Server database. Minimal testing was done against a PostgreSQL database.
</td>
</tr>
</tbody>
</table>
</div>
<li>i2b2 Web Client</li>
</ul>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>The Web Client contains only one minor fix to the wording of an error message. Upgrading to the new Web Client is not essential for this release. Please see the <a href="#rel1708achgSumWebClient">Change Summary - i2b2 Web Client Software</a> section to see what was changed.
</td>
</tr>
</tbody>
</table>
</div>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1708achgSumCore">Change Summary - i2b2 Core Software - Release 1.7.08a</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-241">CORE-241</a>] - Queries will immediately move to the next queue when timeout is < or = to 0
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-236">CORE-236</a>] - Error returned when query times out
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-242">CORE-242</a>] - Queries are stuck in queue when previous query results in an error
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-243">CORE-243</a>] - Queries do not stop running when they time out of the large queue
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-244">CORE-244</a>] - Statuses are not updated when query times out or an error occurs
</li>
</ul>
<!-- #NOTE: WEB CLIENT SECTION -->
<h2 id="rel1708achgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.08a</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-205">WEBCLIENT-205</a>] - Update date constraint warning message (patient_dimension)
</li>
</ul>
<br>
<hr>
<!-- #NOTE: Start of Release 1.7.08 -->
<h1 id="rel1708">i2b2 Release 1.7.08</h1>
<p class="releaseDate"><b>Release Date:</b> October 7, 2016</p>
<h2 id="rel1708Summary">1.7.08 Release Summary</h2>
<p>Release 1.7.08 contains a number of new features as well as bug fixes. Below are a few highlights of the changes included in this release. Information about the other changes can be found in the sections that follow this one.</p>
<h3 id="rel1708summary-wildfly">JBoss Updated to WildFly</h3>
<p>In order to address some of the security vulnerabilities that exist in some JBoss installations, the i2b2 Server has been upgraded to use WildFly. In 2014 Red Hat renamed their JBoss Application Server to WildFly and their latest version (WildFly 10) addresses the known security vulnerabilities.</p>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>
<br>The <a href="#rel1708otherSoftwareUpdates">Third Party Software Changes</a> section contains additional information on upgrading WildFly as well as other 3rd party software.
<br>
<br>Although we recommend upgrading to WildFly, we do recognize that some sites may not be in a position to upgrade their existing JBoss 7. In the section labeled <a href="#rel1708-wildflyProperties">i2b2 Property Settings for WildFly 10 and JBoss 7</a> we have documented all the places you will need to modify the paths in order to use 1.7.08 with your existing JBoss 7. We have also included some additional information that you will need to be aware of before using 1.7.08 with your existing JBoss,
</td>
</tr>
</tbody>
</table>
</div>
<h3 id="rel1708summary-tempTable">SQL Server: Option to Improve Query Performance</h3>
<p>New parameter to use temp table constraint instead of 'WITH' clause.
</p>
<p>Large data warehouses that contain broad and deep ontologies run the risk of CRC queries having a slow response time. In this release (1.7.08) a new parameter has been added to the <b>crc.properties</b> file. This new parameter allows a site to use a temp table instead of a <b>'WITH'</b> clause when running a CRC query.
</p>
<p>
<b><i>Additional information about this new feature can be found in the <a href="#rel1708newFeatureDetails">Improvement / New Feature Details</a> section under the <a href="#rel1708newFeatureDetails-tempTable">SQL Server: Option to Improve Query Performance</a> heading.</i></b>
</p>
<h3 id="rel1708summary-queues">Improvements to the Processing of Queueing Queries</h3>
<p>In the Previous Query display, new statuses provide users with additional information that accurately reflects the current status and location of the query. The <b>new</b> statuses are:</p>
<ul>
<li>SMALL_QUEUE</li>
<li>SMALL_QUEUE_RUNNING</li>
<li>MEDIUM_QUEUE</li>
<li>MEDIUM_QUEUE_RUNNING</li>
<li>LARGE_QUEUE</li>
<li>LARGE_QUEUE_RUNNING</li>
</ul>
<p>In addition to updating the status of queries, an additional feature was added to the Web Client that makes these statuses visible to users. The query status can be seen in <b>Previous Queries</b> as well as in <b>Show Query Status</b>.</p>
<p><b><i>A complete list of all the statuses as well as additional information about this new feature can be found in the <a href="#rel1708newFeatureDetails">Improvement / New Feature Details</a> section under the <a href="#rel1708newFeatureDetails-queues">Improvements to the Processing of Queueing Queries</a> heading.</i></b>
</p>
<h2 id="rel1708shrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="http://community.i2b2.org/wiki/download/attachments/14091090/shrineApprvl_v1-21-02.png" alt="Shrine Approval"><i>SHRINE Release 1.21.2</i> has been tested with <i>i2b2 1.7.08 Release</i> and has been <b>approved</b> by the SHRINE Team</p>
<h2 id="rel1708installNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.08</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.08 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1708upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.08 contains changes to the following software components:
</p>
<ul>
<li>Database Scripts</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
</ul>
<!-- #NOTE: 3rd party changes -->
<h2 id="rel1708otherSoftwareUpdates">Third Party Software Changes</h2>
<p>In release 1.7.08 the <b>i2b2 Server</b> has been updated to use the following versions of third party software. These updates were done to address some security concerns with the third party software used by the i2b2</p>
<ol>
<li>Apache Ant has been upgraded to 1.9</li>
<li>Apache Axis2 has been upgraded to 1.7.1</li>
<li>Java JDK has been upgraded to 8.0</li>
<li>JBoss has been upgraded to WildFly 10</li>
</ol>
<h3 id="rel1708otherSoftwareTable">3rd Party Software Versions and Links</h3>
<p>The following table contains all the information needed to update your 3rd party software. In addition to the version information, the table contains links both to the Vendor's documentation as well as the appropriate chapter in the <a href="http://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">i2b2 Installation Guide</a> located on the i2b2 Community Wiki.</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">3rd Party Software</th>
<th class="i2b2-th">Version</th>
<th class="i2b2-th">Download Link</th>
<th class="i2b2-th">Vendor Documentation</th>
<th class="i2b2-th">i2b2 Installation Guide</th>
<th class="i2b2-th">i2b2 Notes</th>
</tr>
<tr>
<td class="i2b2-td"><b>Apache Ant</b>
</td>
<td class="i2b2-td">1.9</td>
<td class="i2b2-td">
<a href="https://ant.apache.org/bindownload.cgi">Apache Ant 1.9 Software</a>
</td>
<td class="i2b2-td">Ant's manual and API documentation is included in the binary distribution.</td>
<td class="i2b2-td"></td>
<td class="i2b2-td"></td>
</tr>
<tr>
<td class="i2b2-td"><b>Apache Axis2</b>
</td>
<td class="i2b2-td">1.7.1</td>
<td class="i2b2-td"><a href="http://archive.apache.org/dist/axis/axis2/java/core/1.7.1/">Axis2 1.7.1 Software</a>
</td>
<td class="i2b2-td"><a href="http://axis.apache.org/axis2/java/core/docs/installationguide.html">Installation Guide</a>
</td>
<td class="i2b2-td"><a href="http://community.i2b2.org/wiki/display/getstarted/2.4.4+Apache+Axis2">Apache Axis2</a>
</td>
<td class="i2b2-td">Download the WAR Distribution File</td>
</tr>
<tr>
<td class="i2b2-td"><b>Java JDK</b>
</td>
<td class="i2b2-td">8.0</td>
<td class="i2b2-td">
<a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html"></a>JDK 8 Software</td>
<td class="i2b2-td"></td>
<td class="i2b2-td"><a href="http://community.i2b2.org/wiki/display/getstarted/2.4.1+Java+JDK">Java JDK</a>
</td>
<td class="i2b2-td">Reminder: Update your JAVA_HOME environment variable to point to JDK 8.0</td>
</tr>
<tr>
<td class="i2b2-td"><b>WildFly</b>
</td>
<td class="i2b2-td">10</td>
<td class="i2b2-td">
<a href="http://wildfly.org/downloads/"></a>WildFly 10 Software</td>
<td class="i2b2-td"><a href="https://docs.jboss.org/author/display/WFLY10/Getting+Started+Guide">Getting Started Guide</a>
</td>
<td class="i2b2-td"></td>
<td class="i2b2-td"></td>
</tr>
</table>
<!-- #NOTE: WildFly Properties Section -->
<h3 id="rel1708-wildflyProperties">i2b2 Property Settings for WildFly 10 and JBoss 7</h3>
<div class="i2b2-panel">
<table class="i2b2-warning">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_warn.png" width="16" height="16" align="absmiddle" alt="warning" border="0">
</td>
<td>
<b>Warning</b>
<br>As stated earlier, the i2b2 team made the decision to upgrade to WildFly 10 and JDK 8 in order to address known security vulnerabilities with JBoss. In order for the i2b2 server (1.7.08) to work correctly, we recommend you update your environment to use WildFly 10 and JDK 8. However, if you are currently using JBoss 7 and do not want to upgrade your environment to use WildFly there are a few things you need to be aware of.
<ol>
<li>Release 1.7.08 was <b>not tested</b> with <i>JBoss 7</i>, therefore we cannot guarantee the stability of the release if you continue to use JBoss 7. We can however confirm the i2b2 server (1.7.08) was tested with WildFly 10 and JDK 8 and does work correctly.</li>
<li>JDK 8 does not work with JBoss 7. If you are upgrading to JDK8 then you have to upgrade to WildFly</li>
</ol>
<br>If you are upgrading to WildFly and JDK 8 you need to do these upgrades <b><i>before</i></b> you upgrade your i2b2 server code.
</td>
</tr>
</tbody>
</table>
</div>
<p>
The property settings delivered with i2b2 version 1.7.08 are pointing to WildFly. For those sites that are currently using JBoss 7 and are not ready to upgrade to WildFly 10 you will need to change the path information to point to JBoss 7. The files and properties that need to be modified are in the next section.
</p>
<h4 id="rel1708-wildflyPropertyEdits">WildFly Property Modifications</h4>
<h5 id="rel1708-wildflyProperties-CRC">CRC Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> crc_application_directory.properties
<br>
<b>Location:</b> edu.harvard.i2b2.crc/etc/spring/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.crc.applicationdir</span>=/opt/wildfly-10.0.0.Final/standalone/configuration/crcapp</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.crc.applicationdir</span>=/opt/jboss-as-7.1.1.Final/standalone/configuration/crcapp</td>
</tr>
</table>
<br class="i2b2-br-large">
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.crc/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-FR">File Repository Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> fr_application_directory.properties
<br>
<b>Location:</b> edu.harvard.i2b2.fr/etc/spring/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.fr.applicationdir</span>=/opt/wildfly-10.0.0.Final/standalone/configuration/frapp</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.fr.applicationdir</span>=/opt/jboss-as-7.1.1.Final/standalone/configuration/frapp</td>
</tr>
</table>
<br class="i2b2-br-large">
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.fr/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-IM">Identity Management (IM) Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> im_application_directory.properties
<br>
<b>Location:</b> edu.harvard.i2b2.im/etc/spring/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.im.applicationdir</span>=/opt/wildfly-10.0.0.Final/standalone/configuration/imapp</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.im.applicationdir</span>=/opt/jboss-as-7.1.1.Final/standalone/configuration/imapp</td>
</tr>
</table>
<br class="i2b2-br-large">
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.im/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-ONT">Ontology Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> ontology_application_directory.properties
<br>
<b>Location:</b> edu.harvard.i2b2.ontology/etc/spring/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.ontology.applicationdir</span>=/opt/wildfly-10.0.0.Final/standalone/configuration/ontologyapp</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.ontology.applicationdir</span>=/opt/jboss-as-7.1.1.Final/standalone/configuration/ontologyapp</td>
</tr>
</table>
<br class="i2b2-br-large">
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.ontology/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-PM">PM Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.pm/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-serverCommon">Server-Common Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.server-common/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<br class="i2b2-br-large">
<h5 id="rel1708-wildflyProperties-WORK">Workplace Cell Property Changes</h5>
<p class="i2b2-para-indent-1">
<b>File Name:</b> workplace_application_directory.properties
<br>
<b>Location:</b> edu.harvard.i2b2.workplace/etc/spring/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.workplace.applicationdir</span>=/opt/wildfly-10.0.0.Final/standalone/configuration/workplaceapp</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">edu.harvard.i2b2.workplace.applicationdir</span>=/opt/jboss-as-7.1.1.Final/standalone/configuration/workplaceapp</td>
</tr>
</table>
<br class="i2b2-br-large">
<p class="i2b2-para-indent-1">
<b>File Name:</b> build.properties
<br>
<b>Location:</b> edu.harvard.i2b2.workplace/
</p>
<table class="i2b2-table-noBorder">
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>WildFly 10 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/wildfly-10.0.0.Final</td>
</tr>
<tr class="i2b2-tr-noBorder">
<td class="i2b2-td-noBorder"><b>JBoss 7 path:</b>
</td>
<td class="i2b2-td-noBorder"><span style="color:#a71d5d">jboss.home</span>=/opt/jboss-as-7.1.1.Final</td>
</tr>
</table>
<!-- #NOTE: CORE SOFTWARE SECTION -->
<h2 id="rel1708chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.08</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-214">CORE-214</a>] - Upgrade JBoss to WildFly
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-216">CORE-216</a>] - Change GetTermInfo from a like clause to an equal clause
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-221">CORE-221</a>] - Improvements to the queuing process when running a query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-229">CORE-229</a>] - Provide updated JDBC drivers used by Oracle, PostgreSQL, and SQL Server
</li>
</ul>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-218">CORE-218</a>] - New web service to retrieve the db lookup settings in the configuration files
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-226">CORE-226</a>] - New parameter to use temp table constraint instead of 'WITH' clause
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-227">CORE-227</a>] - Add ability to send parameters with string based variables as varchar instead of nvarchar
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-151">CORE-151</a>] - Modifiers associated to inactive terms appear as active in hierarchical tree
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-184">CORE-184</a>] - Generated SQL is not escaping single quotes correctly if a space exists between multiple values in C_DIMCODE
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-206">CORE-206</a>] - Query failing to time out into processing queue
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-208">CORE-208</a>] - qt_privilege primary key
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-211">CORE-211</a>] - Some large queries are remaining in the medium queue
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-220">CORE-220</a>] - SqlServer Age at Visit incorrect for 24, 80, 81 and 89
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-230">CORE-230</a>] - SQL Server: Issue with non-clustered index on temp tables
</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-188">CORE-188</a>] - Unable to change AGG_SERVICE_ACCOUNT password
</li>
</ul>
<!-- #NOTE: WEB CLIENT SECTION -->
<h2 id="rel1708chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.08</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-133">WEBCLIENT-133</a>] - Restrict ability to add Date Constraint if a panel contains any age concepts.
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-192">WEBCLIENT-192</a>] - Improvements to queued queries in status window
</li>
</ul>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-191">WEBCLIENT-191</a>] - ADMIN: Add the ability to view DB_LOOKUP settings for each cell
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-198">WEBCLIENT-198</a>] - Parameters/Configurations for Web Client
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-98">WEBCLIENT-98</a>] - Updating the "Annotate" option is not reflecting on mouse hover
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-157">WEBCLIENT-157</a>] - Concept codes are displayed in tooltip even when the option is not selected
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-160">WEBCLIENT-160</a>] - Previous query panel right click menu is not not functional under Find tab and menu option display is persistant once displayed
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-161">WEBCLIENT-161</a>] - Max queries option under Previous queriesl/ontology terms panel allowing non integer and blank values
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-170">WEBCLIENT-170</a>] - Query run without selecting any run option is putting the query in processing queue
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-171">WEBCLIENT-171</a>] - query run with long name( more than 42 characters) is resulting in query time out and with larger number is giving sql error
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-175">WEBCLIENT-175</a>] - Group buttons at bottom of Query Tool will sometimes "disappear" after Printing the Query Report
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-180">WEBCLIENT-180</a>] - Set Modifier Value is not always an option when adding a previous query to the Query Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-181">WEBCLIENT-181</a>] - Web Client doesn't fully logout when logging out after the timeout message
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-184">WEBCLIENT-184</a>] - "Not" does not appear if Group 4 or greater is excluded
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-189">WEBCLIENT-189</a>] - Modifiers repeat when prompted to increase number of terms in web client
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-190">WEBCLIENT-190</a>] - Modifiers associated to inactive terms appear as active in hierarchical tree
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-193">WEBCLIENT-193</a>] - Admin appears to crash when clicking on DB-Lookup for IM cell
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-195">WEBCLIENT-195</a>] - Fix names and fields that display on each of the new DBLookup pages
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-197">WEBCLIENT-197</a>] - New date constraint warning appears even if demographics are not in panel
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-199">WEBCLIENT-199</a>] - db_lookup
</li>
</ul>
<!-- #NOTE: COMMUNITY PLUGINS SECTION -->
<h2 id="rel1708chgSumPlugins">Change Summary - i2b2 Community Plugins - Release 1.7.08</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-17">PLUGINS-17</a>] - Plugins manifest is pointing to the wrong URL
</li>
</ul>
<!-- #NOTE New Feature Details -->
<h2 id="rel1708newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1708newFeatureDetails-DbLookup">View and Update the DB_LOOKUP Tables</h3>
<p class="jiraIssue">JIRA ISSUES:
<br> [<a href="http://community.i2b2.org/jira/browse/CORE-218">CORE-218</a>] - New web service to retrieve the db lookup settings in the configuration files
<br> [<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-191">WEBCLIENT-191</a>] - ADMIN: Add the ability to view DB_LOOKUP settings for each cell
</p>
<p>
Release 1.7.08 added the ability to view current database connections defined in the DB_LOOKUP tables for each i2b2 cells. Administrators can also edit existing values and add new entries into the tables. This new feature resides within the i2b2 Admin Module. The DB_LOOKUP tables are specific to each i2b2 cell. To access the list of values in a specific cell you need to expand Manage Cells in the Navigation Tree on the left of the page. Then select the cell to expand further, once this is done you will see DB-Lookup as an option. Clicking on DB-Lookup will display the DBLookup List page. This page will display all the values in a table format.
</p>
<p>
The following screen shot shows all the entries in the CRC_DB_LOOKUP table.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup.png">
<img src="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup.png" alt="DB Lookup" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>
To add a new entry into the DB_LOOKUP table simply click on the <b>Add New DBLookup</b> button that appears above the table of existing values. The page will be updated to a form with fields to capture the information to be stored in the DB_LOOKUP table.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup-new.png">
<img src="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup-new.png" alt="DB Lookup New Entry" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>
To edit an existing entry, click on its Name located in the Navigation Tree on the left. The page will be updated to show the values currently filed in the DB_LOOKUP table. Make any changes and click on <b>Save</b> to save your edits.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup-edit.png">
<img src="http://community.i2b2.org/wiki/download/attachments/14091090/dbLookup-edit.png" alt="DB Lookup Edit" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<!-- #NOTE ENHANCEMENT GROUP 2: -->
<h3 id="rel1708newFeatureDetails-queues">Improvements to the Processing of Queueing Queries</h3>
<p class="jiraIssue">JIRA ISSUES:
<br> [<a href="http://community.i2b2.org/jira/browse/CORE-221">CORE-221</a>] - Improvements to the queuing process when running a query
<br> [<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-192">WEBCLIENT-192</a>] - Improvements to queued queries in status window
</p>
<p>
In the i2b2, there are three queues a query may be placed into when it is run. The length of time a query waits in each queue is defined in the crc.properties file.
</p>
<ol>
<li>Small Queue</li>
<li>Medium Queue</li>
<li>Large Queue</li>
</ol>
<p>
In the Web Client, the status of a query can be seen in Previous Queries. The status would be <i>PROCESSING</i>, <i>ERROR</i>, or <i>COMPLETED</i>. None of these statuses would provide information on which queue the query was in. Database administrators would have to view the query in the QT_QUERY_INSTANCE table to see the queue information. The statuses and queue information were often ambiguous which would make it challenging to trouble shoot any issues.
</p>
<p>
To address this issue, new statuses have been added in Release 1.7.08. These new statuses provide users with additional information that accurately reflects the current status and location of the query. The new statuses are:
</p>
<ol>
QUEUED ERROR COMPLETED PROCESSING SMALL_QUEUE MEDIUM_QUEUE LARGE_QUEUE MEDIUM_QUEUE_RUNNING LARGE_QUEUE_RUNNING RUNNING
</ol>
<p>
In addition to updating the status of queries, an additional feature was added to the Web Client that makes these statuses visible to users. The query status can be seen in <b>Previous Queries</b> as well as in <b>Show Query Status</b>.
</p>
<!-- #NOTE ENHANCEMENT GROUP 3: -->
<h3 id="rel1708newFeatureDetails-tempTable">SQL Server: Option to Improve Query Performance</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-226">CORE-226</a>] - New parameter to use temp table constraint instead of 'WITH' clause
</p>
<p>
Large data warehouses that contain broad and deep ontologies run the risk of CRC queries having a slow response time. In this release (1.7.08) a new parameter has been added to the <b>crc.properties</b> file. This new parameter allows a site to use a temp table instead of a '<b>WITH</b>' clause when running a CRC query. In some environments, using a temp table allows the query to run more efficiently and process the request faster.
</p>
<p>
<b>Parameter Name:</b> edu.harvard.i2b2.crc.setfinderquery.constraintlogic
<br>
<b>Located in:</b> crc.properties file
<br>
<b>Behavior:</b>
</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">Value</th>
<th class="i2b2-th">Behavior</th>
</tr>
<tr>
<td class="i2b2-td">TEMP or TEMPTABLES</td>
<td class="i2b2-td">Temp tables will be used when building queries.</td>
</tr>
<tr>
<td class="i2b2-td">WITH</td>
<td class="i2b2-td">Current query logic is used</td>
</tr>
</table>
<p>
If the parameter is missing from the crc.properties file, the system will current query logic (WITH clause).
</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Important</b>
<br>This change only affects SQL Server databases. Both PostgreSQL and Oracle do not have the capabilities of using temp tables. They will continue to use the WITH clause.</td>
</tr>
</table>
</div>
<!-- #NOTE ENHANCEMENT GROUP 4: -->
<h3 id="rel1708newFeatureDetails-dateConstraint">Date Constraint Improvements</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-133">WEBCLIENT-133</a>] - Restrict ability to add Date Constraint if a panel contains any age concepts.
</p>
<p>
In the i2b2, the CRC will use the START_DATE in the OBSERVATION_FACT table when running a query with a date constraint defined on a panel. This can present a problem if at least one of the items in the panel is an age concept and the patient demographics are stored in the PATIENT_DIMENSION table. The problem is ages that are stored in the PATIENT_DIMENSION table will not have a START_DATE and therefore the date constraint is not valid.
</p>
<p>
General i2b2 users do not know whether or not an age has a start date and if they select a date constraint their query may not return the expected results. This becomes a bigger issue when you are using the i2b2 in a larger network in which some sites may store it in the PATIENT_DIMENSION and others in the OBSERVATION_FACT. This scenario will definitely result in misleading results and the user will be unaware of the discrepancy.
</p>
<p>
To avoid any confusion or misleading results, users can no longer add a date constraint if at least one item in the panel is an age concept. The following message will appear when attempting to set a date constraint on a panel with an age concept:
<em>Date constraints are not allowed for age related concepts. This panel contains at least one age related concepts, therefore a date constraint can not be set for this panel."</em>
</p>
<!-- #NOTE ENHANCEMENT GROUP 5: -->
<h3 id="rel1708newFeatureDetails-paramConfig">Web Client Configurations</h3>
<p class="jiraIssue">JIRA ISSUES: [
<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-198">WEBCLIENT-198</a>] - Parameters/Configurations for Web Client
</p>
<p>
In Release 1.7.08, a new configuration file has been added to the i2b2 Web Client. This file allows site administrators to customize the text on the login screens, default user id and password values, as well as how obfuscated results display in the i2b2 Web Client.
</p>
<p>
<b>File Name:</b> i2b2_ui_config.js <b>File Location: </b> /webclient/js-i2b2/
</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">Parameter</th>
<th class="i2b2-th">Description</th>
<th class="i2b2-th">Default Value</th>
</tr>
<tr>
<td class="i2b2-td">titleLogoSrc</td>
<td class="i2b2-td">Logo that appears in toolbar when logged into the i2b2 Web Client.</td>
<td class="i2b2-td">"assets/images/title.gif"</td>
</tr>
<tr>
<td class="i2b2-td">loginHeaderText</td>
<td class="i2b2-td">Text in the header bar of the login box</td>
<td class="i2b2-td">"i2b2 Login"</td>
</tr>
<tr>
<td class="i2b2-td">loginUsernameText</td>
<td class="i2b2-td">Text for the username input of the login box.</td>
<td class="i2b2-td">"Username:"</td>
</tr>
<tr>
<td class="i2b2-td">loginDefaultUsername</td>
<td class="i2b2-td">Default text inside the username input.</td>
<td class="i2b2-td">"demo"</td>
</tr>
<tr>
<td class="i2b2-td">loginPasswordText</td>
<td class="i2b2-td">Text for the password input of the login box.</td>
<td class="i2b2-td">"Password:"</td>
</tr>
<tr>
<td class="i2b2-td">loginDefaultPassword</td>
<td class="i2b2-td">Default text inside the password input.</td>
<td class="i2b2-td">"demouser"</td>
</tr>
<tr>
<td class="i2b2-td">loginHostText</td>
<td class="i2b2-td">Text for the PM cell dropdown of the login box.</td>
<td class="i2b2-td">"i2b2 Host:"</td>
</tr>
<tr>
<td class="i2b2-td">obfuscatedDisplayNumber</td>
<td class="i2b2-td">The number to display after the plus/minus for obfuscated results.
<br><b>Please see the important note at end of this table.</b>
</td>
<td class="i2b2-td">3
</td>
</tr>
<tr>
<td class="i2b2-td">useFloorThreshold</td>
<td class="i2b2-td">If <b>true</b>, any result below floorThresholdNumber shows as '{floorThresholdText} {floorThresholdNumber}'
<br>If <b>false</b>, floor threshold will not be used when displaying values in the i2b2 Web Client.</td>
<td class="i2b2-td">false</td>
</tr>
<tr>
<td class="i2b2-td">floorThresholdNumber</td>
<td class="i2b2-td">Threshold for the low number of results</td>
<td class="i2b2-td">10</td>
</tr>
<tr>
<td class="i2b2-td">floorThresholdText</td>
<td class="i2b2-td">Text that is prefixed before {floorThresholdNumber} (include trailing space)</td>
<td class="i2b2-td">"Less Than "</td>
</tr>
</table>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Important</b>
<br>The calculation for the real obfuscation value continues to be controlled by the server and is based on the value defined in the CRC properties file. The <b>obfuscatedDisplayNumber</b> parameter in the <b>i2b2_ui_config.js</b> simply defines what number to display to the user when viewing the query results.
</td>
</tr>
</table>
</div>
<!-- #NOTE ENHANCEMENT GROUP 6: -->
<h3 id="rel1708newFeatureDetails-stringParam">SQL Server: New Connection Parameter to Pass in String Based Variables</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-227">CORE-227</a>] - Add ability to send parameters with string based variables as varchar instead of nvarchar
</p>
<p>
Prior to release 1.7.08, parameters are sent in as Unicode (nvarchar) instead of varchar. SQL Server then has to explicitly convert the nvarchar to varchar in the query. The effect is that SQL Server optimizer may have to use an index scan instead of an index seek (which is faster).
</p>
<p>
To address this issue, we have added a new connection parameter to be used when i2b2 uses PreparedStatements to pass in string based variables in SQL Server. The following connection parameter is to be added to the datasource definition.
</p>
<p>
<b>Connection Parameter:</b> connection-property name="sendStringParametersAsUnicode"
<br>
<b>Added To:</b> datasource definition
<br>
<b>Behavior:</b>
</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">Value</th>
<th class="i2b2-th">Behavior</th>
</tr>
<tr>
<td class="i2b2-td">false</td>
<td class="i2b2-td">String based variable will be sent as varchar</td>
</tr>
<tr>
<td class="i2b2-td">true</td>
<td class="i2b2-td">Current logic is used; String based variable will be sent in Unicode (nvarchar)</td>
</tr>
</table>
<p>
<b><i>Example:</i></b> <connection-property name="sendStringParametersAsUnicode" >false</connection-property>
</p>
<!-- #NOTE ENHANCEMENT GROUP 7: -->
<h3 id="rel1708newFeatureDetails-JDBCdriverUpdate">Updated JDBC Drivers</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-229">CORE-229</a>] - Provide updated JDBC drivers used by Oracle, PostgreSQL, and SQL Server</p>
<p>
Included in release 1.7.08 are updated JDBC drivers for Oracle, PostgreSQL and SQL Server. The new version of JDBC drivers are optional and will not be installed automatically.
</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Important</b>
<br>Sites that choose to upgrade their JDBC drivers will be required to also updated the datasource files for all of their cells.</td>
</tr>
</table>
</div>
<h4 id="rel1708newFeatureDetails-JDBCdriverUpdate-how">Information on Updating Drivers</h4>
<p>
This section contains some general information and key points to keep in mind when updating your JDBC drivers.
</p>
<h5>Location of JDBC Jar files</h5>
<p>
Your current JDBC jar files reside in the following directories:
</p>
<ol>
<li>${jboss.home}/standalone/deployments/${axis2.war.name}/WEB-INF/lib</li>
<li>${jboss.home}/standalone/deployments</li>
</ol>
<h5>New Version of JDBC</h5>
<p>There are three new jar files, one for each type of supported databases.
</p>
<ol>
<li>Oracle = ojdbc7.jar</li>
<li>PostgreSQL = postgresql-9.4-1209.jar</li>
<li>SQL Server = sqljdbc42.jar</li>
</ol>
<h5>Update Existing i2b2 Instance</h5>
<p>
A script to deploy the new jar files has been included in the 1.7.08 Release. Once you have updated your server with the latest code you can run one of the following commands to deploy the new jdbc jar files:
</p>
<div class="i2b2-panel">
<table class="i2b2-command">
<tr>
<td>
<b>Linux Command</b>
<br> ant copy_new_jdbc_jar</td>
</tr>
</table>
</div>
<div class="i2b2-panel">
<table class="i2b2-command">
<tr>
<td>
<b>Windows Command</b>
<br> %ANT_HOME%\bin\ant.bat copy_new_jdbc_jar</td>
</tr>
</table>
</div>
<div class="i2b2-panel">
<table class="i2b2-warning">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_warn.png" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Warning</b>
<br>If you choose to install the new JDBC jar files you also need to <b>update your datasource files</b> with the new driver information. This needs to be done for each cell in the i2b2 hive.</td>
</tr>
</table>
</div>
<hr>
<h1 id="rel1707c">i2b2 Release 1.7.07c</h1>
<p class="releaseDate"><b>Release Date:</b> June 7, 2016</p>
<h2 id="rel1707cinstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.07c</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.07c from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1707cshrineApprvl">SHRINE Approval</h2>
<!--
<p class="shrineApprvTxt"> <img class="shrineApprvlImg" src="https://community.i2b2.org/wiki/download/attachments/10519004/shrineApprvl_v1-20-01.png" alt="Shrine Approval"><i>SHRINE Release 1.20.1</i> has been tested with <i>i2b2 1.7.07 Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<p>Release 1.7.07c does not include any server changes and therefore does not affect SHRINE installations. This release does not need to be tested with the latest version of the SHRINE Software.</p>
<h2 id="rel1707cupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.07c contains changes to the following software components:
</p>
<ul>
<li>i2b2 Web Client</li>
<li>i2b2 Server - Admin code only</li>
</ul>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>The Admin changes can be found in the i2b2core-src-1707c zip file located on the software page of the i2b2.org website. Please note that the other server components are included in this file. If you are upgrading from 1.7.07 then you do not need to update your i2b2 server as there are no changes. If you are upgrading from a release prior to 1.7.07 then you do need to install these other components.
<br>
</td>
</tr>
</tbody>
</table>
</div>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.07c</p>
<h2 id="rel1707cchgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.07c</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-186">WEBCLIENT-186</a>] - Timeout message not returned when query runs longer than the defined 180 secs
</li>
</ul>
<hr>
<h1 id="rel1707b">i2b2 Release 1.7.07b</h1>
<p class="releaseDate"><b>Release Date:</b> March 1, 2016</p>
<h2 id="rel1707binstallNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.07b</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.07b from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1707bshrineApprvl">SHRINE Approval</h2>
<!--
<p class="shrineApprvTxt"> <img class="shrineApprvlImg" src="https://community.i2b2.org/wiki/download/attachments/10519004/shrineApprvl_v1-20-01.png" alt="Shrine Approval"><i>SHRINE Release 1.20.1</i> has been tested with <i>i2b2 1.7.07 Release</i> and has been <b>approved</b> by the SHRINE Team</p>
-->
<p>Release 1.7.07b does not include any server changes and therefore does not affect SHRINE installations. This release does not need to be tested with the latest version of the SHRINE Software.</p>
<h2 id="rel1707bupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.07b contains changes to the following software components:
</p>
<ul>
<li>i2b2 Web Client</li>
<li>i2b2 Server - Admin code only</li>
</ul>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>The Admin changes can be found in the i2b2core-src-1707b zip file located on the software page of the i2b2.org website. Please note that the other server components are included in this file. If you are upgrading from 1.7.07 then you do not need to update your i2b2 server as there are no changes. If you are upgrading from a release prior to 1.7.07 then you do need to install these other components.
<br>
</td>
</tr>
</tbody>
</table>
</div>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.07b</p>
<h2 id="rel1707bchgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.07b</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-177">WEBCLIENT-177</a>] - PHP Proxy Update
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-178">WEBCLIENT-178</a>] - Error returned when reloading the i2b2 Web Client after it times out
</li>
</ul>
<hr>
<h1 id="rel1707">i2b2 Release 1.7.07</h1>
<p class="releaseDate"><b>Release Date:</b> January 15, 2016</p>
<h2 id="rel1707installNotes">Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.07</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.07 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1707shrineApprvl">SHRINE Approval</h2>
<p class="shrineApprvTxt">
<img class="shrineApprvlImg" src="https://community.i2b2.org/wiki/download/attachments/10519004/shrineApprvl_v1-20-01.png" alt="Shrine Approval"><i>SHRINE Release 1.20.1</i> has been tested with <i>i2b2 1.7.07 Release</i> and has been <b>approved</b> by the SHRINE Team</p>
<h2 id="rel1707upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.07 contains changes to the following software components:
</p>
<ul>
<li>i2b2 Community Plugins</li>
<li>i2b2 Data</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.07</p>
<h2 id="rel1707chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.07</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-118">CORE-118</a>] - Increase number of queries that can be run in the "lifetime" of the database
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-187">CORE-187</a>] - Split the observation_fact_demo_insert_data script into smaller scripts
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-194">CORE-194</a>] - Split the icd10_icd9_diagnoses_insert_data script into smaller scripts
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-201">CORE-201</a>] - Update i2b2 demo data scripts to support Microsoft SQL Server 2012
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-182">CORE-182</a>] - Wrong datatype defined for some date fields in PostgreSQL create script(s)
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-199">CORE-199</a>] - PM Cell is not sending admin role unless a project is associated to the user
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-202">CORE-202</a>] - Some concepts in concept_dimension have synonym name
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-203">CORE-203</a>] - Restore requirement to look at M_APPLIED_PATH when retrieving modifier info from the Ontology Cell
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-204">CORE-204</a>] - Duplicate data in GitHub repo i2b2-data
</li>
</ul>
<h2 id="rel1707chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.07</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-143">WEBCLIENT-143</a>] - Add .HideBreak() & .getXNodeValNoKids() methods to webclient/js-i2b2/hive/hive_helper.js
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-144">WEBCLIENT-144</a>] - Concepts with a line break in their name are not displaying correctly in the Timeline
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-145">WEBCLIENT-145</a>] - Add reference for jquery-1.11.3.min.js in /webclient/default.htm
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-146">WEBCLIENT-146</a>] - New drop down that will display the list of plugins
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-155">WEBCLIENT-155</a>] - Add 'Delete Temporal Relationship' option to the define order of events screen
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-163">WEBCLIENT-163</a>] - Excluding a panel will now display 'NOT' in front of each item
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-168">WEBCLIENT-168</a>] - Add the ability to expand the Query Status view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-172">WEBCLIENT-172</a>] - Add 'Close' button to new Plugins Menu
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-173">WEBCLIENT-173</a>] - Right-Click "Display" menu to load Previous Query
</li>
</ul>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-162">WEBCLIENT-162</a>] - Item Level Date Constraints
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-164">WEBCLIENT-164</a>] - New i2b2 Web Client Plugin Installer
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-166">WEBCLIENT-166</a>] - Printable Query Report Feature
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-167">WEBCLIENT-167</a>] - Plugin installer configurable parameter in i2b2_config_data.js
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-75">WEBCLIENT-75</a>] - Cannot delete event from temporal query once added in the webclient
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-100">WEBCLIENT-100</a>] - Bar graph overlaps number of patients when large patient set is displayed
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-102">WEBCLIENT-102</a>] - Print Query doesn't display name if printing a previous query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-118">WEBCLIENT-118</a>] - Announcements do not display correctly in Internet Explorer
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-122">WEBCLIENT-122</a>] - Clicking on Login button with missing or invalid username/password is not displaying the right error message
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-125">WEBCLIENT-125</a>] - Wrong icon appears when dragging previous temporal query to Workplace View
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-127">WEBCLIENT-127</a>] - Breakdowns for obfuscated results are not displaying the obfuscation indicator (±3) in Graph Results
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-130">WEBCLIENT-130</a>] - Change Password link show to accounts logged in via AD
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-132">WEBCLIENT-132</a>] - Demographics (1 patient set) plugin
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-135">WEBCLIENT-135</a>] - Some metadata terms with special characters will not run in the query tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-136">WEBCLIENT-136</a>] - Date Constraints lost in webclient when executing a query created in workbench
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-138">WEBCLIENT-138</a>] - Timeline bugs
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-139">WEBCLIENT-139</a>] - Find - Search by Names for non-existent term does not return a message
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-142">WEBCLIENT-142</a>] - "Missing resource" error is being logged because prevQuery.jpg file is missing from /images/
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-147">WEBCLIENT-147</a>] - previous query run results tab displaying obfuscated indicator as '0±3' for counts <3
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-149">WEBCLIENT-149</a>] - Query rerun is failing when run as query-in-query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-150">WEBCLIENT-150</a>] - Find - After Searching, the disappearing "Searching..." text logic is incorrect
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-151">WEBCLIENT-151</a>] - New events in temporal query not populating existing temporal relationships
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-152">WEBCLIENT-152</a>] - Creating multiple New Events without expanding Define Order of Events dropdown is broken
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-153">WEBCLIENT-153</a>] - Previous Queries with special characters do not run in Query Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-158">WEBCLIENT-158</a>] - Minor typos in the webclient
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-176">WEBCLIENT-176</a>] - Blank Page opens in new tab when opening the i2b2 Plugin Gallery
</li>
</ul>
<h2 id="rel1707chgSumPlugins">Change Summary - i2b2 Community Plugins - Release 1.7.07</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-12">PLUGINS-12</a>] - Export XLS: Add field to define delimiter when exporting data to .csv file
</li>
</ul>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-15">PLUGINS-15</a>] - Set up production repositories for all plugins
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-6">PLUGINS-6</a>] - Export XLS: Data does not appear in exported files
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-7">PLUGINS-7</a>] - CARE-Concept: Data does not appear in the exported files
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-8">PLUGINS-8</a>] - CARE-Observation: Data does not appear in the exported files
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-10">PLUGINS-10</a>] - CARE-Concept plugin doesn't display marital statuses
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-11">PLUGINS-11</a>] - CARE-Observation: Marital Statuses are not displaying
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/PLUGINS-16">PLUGINS-16</a>] - Fix issue with double quotes in the manifests for several plugins
</li>
</ul>
<hr>
<h1 id="rel1706">i2b2 Release 1.7.06</h1>
<p class="releaseDate"><b>Release Date:</b> August 12, 2015</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.06</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.06 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1706upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.06 contains changes to the following software components:
</p>
<ul>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
<li>i2b2 Workbench</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.06</p>
<h2 id="rel1706chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.06</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-149">CORE-149</a>] - JDBC calls to interrupted threads throw sqlexceptions - Queries do not leave medium queue
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-165">CORE-165</a>] - Timeline filter not working if database is SQL Server
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-180">CORE-180</a>] - SHRINE queries will not run once i2b2 is updated to 1.7.05
</li>
</ul>
<h3>Documentation Updates</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-179">CORE-179</a>] - Difference between documentation and table concept_dimension
</li>
</ul>
<h2 id="rel1706chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.06</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-110">WEBCLIENT-110</a>] - Temporal queries do not print unless a population is defined
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-115">WEBCLIENT-115</a>] - IE Compatibility tag missing end tag and not within the header
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-116">WEBCLIENT-116</a>] - Graph Results display as "undefined" for obfuscated users
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-117">WEBCLIENT-117</a>] - Query Tool displays behind Query Status and Graph Results tabs
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-120">WEBCLIENT-120</a>] - Print query does not work in Internet Explorer for Previous Temporal Queries
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-121">WEBCLIENT-121</a>] - Previous temporal queries do not run in Internet Explorer
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-123">WEBCLIENT-123</a>] - Order of events not maintained when running a previous temporal query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-124">WEBCLIENT-124</a>] - Clear in Query Tool does not clear correctly for Temporal Queries
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-126">WEBCLIENT-126</a>] - Only able to view the first two events when previous temporal query is added to the query tool
</li>
</ul>
<hr>
<h1 id="rel1705">i2b2 Release 1.7.05</h1>
<p class="releaseDate"><b>Release Date:</b> May 6, 2015</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.05</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.05 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1705upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.05 contains changes to the following software components:
</p>
<ul>
<li>Database Scripts</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
<li>i2b2 Workbench</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.05</p>
<h2 id="rel1705chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.05</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-149">CORE-149</a>] - JDBC calls to interrupted threads throw sqlexceptions
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-156">CORE-156</a>] - PM may not send the correct cell information when multiple projects and cells defined
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-158">CORE-158</a>] - JBoss server log contains password information when debug is turned on
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-159">CORE-159</a>] - Inconsistency in JBoss711Final and Install documentation
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-166">CORE-166</a>] - Hard coded references to I2B2DEMODATA in CRC install files
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-167">CORE-167</a>] - Metadata data install error
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-169">CORE-169</a>] - SHRINE Previous Queries: Path displays in Query Tool instead of item name
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-174">CORE-174</a>] - concept_dimension.concept_cd is nullable in postgresql implementation
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-177">CORE-177</a>] - Workbench may be using the wrong cell data when multiple projects and cells defined
</li>
</ul>
<h2 id="rel1705chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.05</h2>
<h3>New Features</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-78">WEBCLIENT-78</a>] - Ability to refresh in PQ and workplace
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-80">WEBCLIENT-80</a>] - New view: Find Previous Queries
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-89">WEBCLIENT-89</a>] - New Graph Results view to display patient breakdowns in a graph
</li>
</ul>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-85">WEBCLIENT-85</a>] - Display error message to user in Find for previous queries
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-86">WEBCLIENT-86</a>] - Indicator needed to inform users the system is searching when doing a Find
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-88">WEBCLIENT-88</a>] - Category names in Find (Previous Queries) can be misleading
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-103">WEBCLIENT-103</a>] - Add text wrapping capabilities to the i2b2 Web Client
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-73">WEBCLIENT-73</a>] - Wrong name displays when renaming a previous query in Workplace
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-76">WEBCLIENT-76</a>] - Update the I.E. Emulation that is defined in the Web Client <meta> tag
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-81">WEBCLIENT-81</a>] - Not able to select item from pop-up menu in Previous Queries
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-83">WEBCLIENT-83</a>] - Need message to say no results found
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-84">WEBCLIENT-84</a>] - Not able to search Previous Queries if "Any Categories" is selected
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-90">WEBCLIENT-90</a>] - Query Results not cleared when clear query in Query Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-91">WEBCLIENT-91</a>] - Items are not staying with the pointer when dragged to another i2b2 view (Firefox only)
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-92">WEBCLIENT-92</a>] - Refresh icon needs to updated to one with transparent background
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-93">WEBCLIENT-93</a>] - Update the message that appears to users in Graph Results if using I.E. 7 or 8
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-94">WEBCLIENT-94</a>] - ONT - Containers Dragable by Default
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-95">WEBCLIENT-95</a>] - Help is not displaying in the Web Client
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-97">WEBCLIENT-97</a>] - Selecting temporal constraint selection "Same encounter" is not changing selection at the individiual group level
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-99">WEBCLIENT-99</a>] - Find view is not resizing properly
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-101">WEBCLIENT-101</a>] - Date picker calendar does not close unless you choose a date
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-105">WEBCLIENT-105</a>] - Previous Queries appear to be missing value constraints when dropped in Query Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-106">WEBCLIENT-106</a>] - Observation details are missing when viewed in Timeline
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-107">WEBCLIENT-107</a>] - Graph Results panel temporarily attached to bottom of Show Query Status panel
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-108">WEBCLIENT-108</a>] - Value constraint window doesn't open in I.E. 11
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-109">WEBCLIENT-109</a>] - Web Client may be using the wrong cell data when multiple projects and cells defined
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-112">WEBCLIENT-112</a>] - Find Terms: Search by Code does not display results returned
</li>
</ul>
<hr>
<h1 id="rel1704">i2b2 Release 1.7.04</h1>
<p class="releaseDate"><b>Release Date:</b> November 13, 2014</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.04</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.04 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1704upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.04 contains changes to the following software components:
</p>
<ul>
<li>Database Scripts</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
<li>i2b2 Workbench</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.04</p>
<h2 id="rel1704chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.04</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-134">CORE-134</a>] - Improve appearance of tooltips in Ontology Views
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-136">CORE-136</a>] - Jump to terms does not display modifiers
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-142">CORE-142</a>] - Add ability to add metadataxml to a modifier from within Edit Terms view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-144">CORE-144</a>] - Add ability to expand inactive folders to view its children
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-61">CORE-61</a>] - The crc_loader (triggered via a web service) does not correctly load data into the patient dimension
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-65">CORE-65</a>] - Ontology term sorting order is case sensitive (should be case insensitive)
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-106">CORE-106</a>] - The tooltip boxes don't always close in the Timeline view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-107">CORE-107</a>] - Duplicate concept appears multiple times in Timeline view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-108">CORE-108</a>] - Times in the tooltips are not always updated
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-109">CORE-109</a>] - The contrast of the different bars of color in the timeline needs to be higher.
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-110">CORE-110</a>] - Full concept not displayed when hovering over it in the timeline
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-112">CORE-112</a>] - Remove hard coded link from the workbench code
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-113">CORE-113</a>] - Browser spelled incorrectly in error message returned
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-114">CORE-114</a>] - Date of birth column is displaying the date and time
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-115">CORE-115</a>] - Can't edit value constraints in timeline view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-130">CORE-130</a>] - SQL stored procedure not inserting required data into PROJECT_ID
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-131">CORE-131</a>] - FRC Error - Unable to get 'destdir' from File Repository Cell
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-132">CORE-132</a>] - commons-dbcp.jar and commons-pool.jar are not present in i2b2 WEB-INF/lib directory
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-139">CORE-139</a>] - DEMO Data: Alkaline Phosphatase (ALP) lab tests are missing from Navigate Terms view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-145">CORE-145</a>] - Users with LDS access can view de-identified data (i.e. reports)
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-148">CORE-148</a>] - Values no longer visible in timeline view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-150">CORE-150</a>] - Left and Right arrows in previous queries not working correctly
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-152">CORE-152</a>] - Wrong approval displays when selecting an approval to edit in the Admin Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-153">CORE-153</a>] - Only the first item in each section of a project request appears in the Admin Tool
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-155">CORE-155</a>] - Base code doesn't display in the Edit Term Wizard
</li>
</ul>
<h2 id="rel1704chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.04</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-67">WEBCLIENT-67</a>] - Add ability to expand inactive items to view its dependents / children
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-13">WEBCLIENT-13</a>] - Data & admin roles specified in Project Request plug-in are listed 'undefined' in admin detail view
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-50">WEBCLIENT-50</a>] - New Events for temporal queries are mislabled after using 'Clear'
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-64">WEBCLIENT-64</a>] - Can't drop previous temporal query into query tool if span of time defined in query
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-65">WEBCLIENT-65</a>] - Date constraint not available for Groups over Group3
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-72">WEBCLIENT-72</a>] - Synonyms issue in 1.7.04 release
</li>
</ul>
<hr>
<h1 id="rel1703a">i2b2 Release 1.7.03a</h1>
<p class="releaseDate"><b>Release Date:</b> August 28, 2014</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.03a</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.03a from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1703aupgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.03a contains changes to the following software components:
</p>
<ul>
<li>i2b2 Web Client</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.03a</p>
<h2 id="rel1703achgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.03a</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-68">WEBCLIENT-68</a>] - Panel timing on anchoring observations can be changed to treat independently or same encounter
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-69">WEBCLIENT-69</a>] - Print Query is only including the information for the first group / panel
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-70">WEBCLIENT-70</a>] - The concept associated with a modifier is not printing when you print the query
</li>
</ul>
<hr>
<h1 id="rel1703">i2b2 Release 1.7.03</h1>
<p class="releaseDate"><b>Release Date:</b> August 20, 2014</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.03</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.03 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1703upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.03 contains changes to the following software components:
</p>
<ul>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.03</p>
<h2 id="rel1703chgSumCore">Change Summary - i2b2 Core Software - Version 1.7.03</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-143">CORE-143</a>] - Do not require M_APPLIED_PATH when retrieving modifier information from the Ontology Cell
</li>
</ul>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-135">CORE-135</a>] - Edit tool to file C_PATH and C_SYMBOL when adding new item</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-141">CORE-141</a>] - Remove carriage returns / line feeds from metadataxml when filing a term in Edit Terms view</li>
</ul>
<h2 id="rel1703chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.03</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-63">WEBCLIENT-63</a>] - Temporal Queries: Wrong description is displaying in the list of constraints for "On or After"</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-66">WEBCLIENT-66</a>] - Wrong operator sent for some temporal relationships</li>
</ul>
<h2 id="rel1703newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1703newFeatureDetails-editToolFilePathAndSymbol">Edit tool to file C_PATH and C_SYMBOL when adding new item</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-135">CORE-135</a>]</p>
<p>In the i2b2 metadata table there are two columns (C_PATH and C_SYMBOL) that are used exclusively by the Ontology Mapping tool. Prior to release 1.7.03 these columns were not populated when you added a new term via the Edit Terms view. This situation has been rectified in that these columns will now be populated with the appropriate data when creating a new container, folder, term, or modifier from within the Edit Terms view.</p>
<h3 id="rel1703newFeatureDetails-editToolLineFeedMetdataXML">Edit Tool view: Line feeds removed from Metadataxml</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-141">CORE-141</a>]</p>
<p>In the Edit Terms view users can create terms that have values associated to them. These values are stored in the C_METADATAXML column in the custom metadata table. Prior to release 1.7.03 when you created or edited a term with values in the Edit Tool view, the metadata was stored in the table with carriage returns / line feeds. This change improves the way the metadataxml if filed into the table by removing all line feeds from the data before filing it into the C_METADATAXML column</p>
<hr>
<h1 id="rel1702">i2b2 Release 1.7.02</h1>
<p class="releaseDate"><b>Release Date:</b> July 1, 2014</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.02</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.02 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1702upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7.02 contains changes to the following software components:
</p>
<ul>
<li>Database Scripts</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
<li>i2b2 Workbench</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.02</p>
<h2 id="rel1702chgSumCore">Change Summary - i2b2 Core Software - Version 1.7.02</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-95">CORE-95</a>] - Password Management Enhancement</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-123">CORE-123</a>] - Update demo patient MRNs and sites</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-26">CORE-26</a>] - "Your account does not have access to any i2b2 projects" in admin webclient</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-36">CORE-36</a>] - Attempt to add a new CEL via the admin webclient fails</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-80">CORE-80</a>] - Date restrict on non obs_fact values not added to generated SQL</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-86">CORE-86</a>] - Ontology contains bad XML</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-91">CORE-91</a>] - PostgreSQL: Error executing CRC stored procedure CREATE_TEMP_PROVIDER_TABLE</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-92">CORE-92</a>] - Wrong user name entered in PM's datasource file for PostgreSQL and SQL Server examples</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-93">CORE-93</a>] - compare integer with varchar</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-94">CORE-94</a>] - Wrong built SQL statement causing SQLSyntaxErrorException at GetPDOFromInputList request</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-97">CORE-97</a>] - User and cell confguration (data) in the Admin module does not display in some browsers</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-98">CORE-98</a>] - Patient breakdown result types are not working when querying a PostgreSQL database</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-99">CORE-99</a>] - Cell data changes made in i2b2 Admin are not saved</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-100">CORE-100</a>] - Error executing CRC stored procedure CREATE_TEMP_PROVIDER_TABLE (PostgreSQL)</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-101">CORE-101</a>] - Error occurs when expanding an Encounter set in Previous Queries</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-102">CORE-102</a>] - PM datasource file has the wrong username listed in the example</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-103">CORE-103</a>] - Error returned from the CRC when running a query with result type of Encounter set</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-116">CORE-116</a>] - On Amazon Demo site, the Visit Detail AGE does not work</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-120">CORE-120</a>] - Change Password displaying in Managers Tool View</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-125">CORE-125</a>] - Query using concepts from the clinical trials folder always returns zero patients</li>
</ul>
<h2 id="rel1702chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.02</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-56">WEBCLIENT-56</a>] - Password Management Enhancement</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-27">WEBCLIENT-27</a>] - Wrong icon appears when dragging folder to Workplace View</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-43">WEBCLIENT-43</a>] - ontology cell concept navigation "Show Synonymous Terms" checkbox inconsistency</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-46">WEBCLIENT-46</a>] - Renaming shared folders doesn't work in the webclient</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-47">WEBCLIENT-47</a>] - "Delete Concept" in I2B2 web app deletes the first occurrence of the concept, not the one selected</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-51">WEBCLIENT-51</a>] - Only 1 temporal relationship sent in xml even though multiple are defined</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-52">WEBCLIENT-52</a>] - Modifier folders/containers don't work with i2b2 v1.7 and PostgreSQL</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-54">WEBCLIENT-54</a>] - When an item in the Term Navigator has more than a certain number of elements underneath, the arithmetic in the 'Need more items' dialog box is incorrect</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-55">WEBCLIENT-55</a>] - With error in data source the client runs on forever</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-58">WEBCLIENT-58</a>] - Operators do not default correctly when adding a temporal relationship</li>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-59">WEBCLIENT-59</a>] - Print Query not working in Chrome browser</li>
</ul>
<h3>Tasks</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-61">WEBCLIENT-61</a>] - Disable changing passwords on the demo site</li>
</ul>
<h2 id="rel1702newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1703newFeatureDetails-pswdMgmt">Password Management</h3>
<p class="jiraIssue">JIRA ISSUES: [<a href="http://community.i2b2.org/jira/browse/CORE-95">CORE-95</a>] and [<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-56">WEBCLIENT-56</a>]</p>
<p>In release 1.7.02, i2b2 users are now able to change their password from within the i2b2 Web Client and Workbench. Previously to this release, users did not have the ability to change their own password. They would have to notify their administrator who would have to change it for them in the i2b2 administration module. This new feature adds a layer of security in that the user can manage their own password and not have the added risk of other users (i.e. the admin) knowing their password.</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>If a user is setup to log into the i2b2 using either Active Directory or LDAP authentication methods then they will <b>not</b> be able to change their password from within the i2b2 Web Client or Workbench. If they need to change their password they will need to contact their site administrator and follow the protocols established at their institution.
<br>
<br><b><i>This feature is only available for those users that log in with the standard i2b2 Authentication method.</i></b>
</td>
</tr>
</tbody>
</table>
</div>
<p>In the i2b2 Web Client, a new option called <b>Change Password</b> now appears in the Web Client's toolbar.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WC_chgPswd_button.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WC_chgPswd_button.png" alt="Change Password in toolbar" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>Clicking on <b>Change Password</b> will open the <b>i2b2 Change Password window</b>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WC_chgPswd_window.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WC_chgPswd_window.png" alt="Change Password Window" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>In the i2b2 Workbench, a new button labeled <b>Password</b> has been added to the i2b2 desktop title bar.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WB_chgPswd_button.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WB_chgPswd_button.png" alt="Change Password button" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>Clicking on <b>Password</b> will open the <b>Set Password window</b>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WB_chgPswd_window.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1702_WB_chgPswd_window.png" alt="Change Password Window" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The functionality to change your password is the same regardless of whether you access the change password window from within the i2b2 Web Client or the workbench. There are basically three steps:</p>
<ol>
<li>Enter your <b>current password</b>.</li>
<li>Enter a <b>new password</b> for your user.</li>
<li><b>Retype</b> your password.</li>
</ol>
<p>Once you do the above three steps and click on <b>OK</b> the system will verify you entered your "current" password correctly and the password you entered at the <i>New Password</i> and <i>Retype Password</i> fields match. Provided everything is correct your new password will be saved.</p>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>Once you change your password you will need to log out of the Web Client or Workbench and log back in using your new password.
</td>
</tr>
</tbody>
</table>
</div>
<hr>
<h1 id="rel1701">i2b2 Release 1.7.01</h1>
<p class="releaseDate"><b>Release Date:</b> February 4, 2014</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7.01</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7.01 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1701upgradeNotes">Upgrade Notes</h2>
<p>i2b2 Release 1.7.01 contains changes to the following software components:</p>
<ul>
<li>Database Scripts</li>
<li>i2b2 Server</li>
<li>i2b2 Web Client</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>No changes to third party software are included in release 1.7.01</p>
<h2 id="rel1701chgSumCore">Change Summary - i2b2 Core Software - Version 1.7.01</h2>
<h3>Improvements</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-88">CORE-88</a>] - Confusing error message logged for non-Oracle users
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-83">CORE-83</a>] - Trying to build and compile i2b2 Server on Fedora Core 20 with Wildfly 8.0.0
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-85">CORE-85</a>] - Fresh install fails on PM Module and admin screen
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-87">CORE-87</a>] - Installation process needs to put database drivers in i2b2.war/WEB-INF/lib
</li>
<li>Data Install: The stored procedures for PostgreSQL for the CRC Loader was enhanced and optimized.</li>
<li>Server Install: JDBC Drivers not copied correctly. When installing i2b2 server-common, the JDBC drivers were not copied into the i2b2.war/WEB-INF/lib directory.</li>
<li>CRC-Loader: Importing Visit Dimension Data. When using the CRC Loader, some primary key data such as inout_cd, location_cd, length_of_visit, etc, was not being imported correctly.</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-58">CORE-58</a>] - Workbench 1.6 and default install
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-77">CORE-77</a>] - I2B2 installation Guide fixes
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-90">CORE-90</a>] - Install Documentation: Wrong schema configurations documented for a PostgreSQL database
</li>
</ul>
<h2 id="rel1701chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.01</h2>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-48">WEBCLIENT-48</a>] - Web client gets into non-functional state
</li>
<li>Clicking on the Clear button does not return the Query Tool to the default settings. When a temporal query is created, and a user clicks on the clear button to start a new query, the Temporal Constraint is changed to "Define sequence of events" and it should default to "Treat all groups independently.</li>
<li>Date constraints not being stored with the previous query. When a date constraint was defined on a query the previous query would not maintain the constraint when you would use it to run another query.</li>
</ul>
<hr>
<h1 id="rel1700">i2b2 Release 1.7</h1>
<p class="releaseDate"><b>Release Date:</b> December 20, 2013</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1700upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7 contains changes to the following software components:
</p>
<ul>
<li>
Database Scripts
</li>
<li>
i2b2 Server
</li>
<li>
i2b2 Web Client
</li>
<li>
i2b2 Workbench
</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>In release 1.7 the <b>i2b2 Server</b> has been updated to use the following versions of third party software.</p>
<ol>
<li>JBoss has been upgraded to 7.1.1</li>
<li>Apache Ant has been upgraded to 1.8.2</li>
<li>Apache Axis2 has been upgraded to 1.6.2</li>
</ol>
<div class="i2b2-panel">
<table class="i2b2-warning">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_warn.png" width="16" height="16" align="absmiddle" alt="warning" border="0">
</td>
<td>
<b>Warning</b>
<br>Only the i2b2 Server was upgraded to use the above versions of JBoss, Ant, and Axis2. The i2b2 Workbench will continue to use the previous versions. As a result, the source codes for the server and the workbench client have different plug-ins for the commons.
<p class="i2b2-panel-list">Server edu.harvard.i2b2.server-common</p>
<p class="i2b2-panel-list">Client edu.harvard.i2b2.common</p>
</td>
</tr>
</tbody>
</table>
</div>
<h2 id="rel1700chgSumCore">Change Summary - i2b2 Core Software - Release 1.7</h2>
<h3>Improvements</h3>
<ul>
<li>Find Terms: New feature called "Jump to Term in Tree"</li>
<li>Previous Query: Filter list by user</li>
<li>Previous Query: Search Previous Queries View</li>
<li>Previous Query: Page through previous queries by date</li>
<li>Database: PROJECT_ID Column added to PATIENT_MAPPING and ENCOUNTER_MAPPING tables (support for new IM cell)</li>
<li>Demo Data: Updated PATIENT_MAPPING table to support the new IM cell.</li>
</ul>
<h3>New Features</h3>
<ul>
<li>Temporal Queries (New Temporal Query Tool View)</li>
<li>Identity Management Cell (IM)</li>
<li>Identity Management Tables</li>
<li>Managers Tool View</li>
<li>OpenEMPI Support</li>
<li>Patient Mapping View</li>
<li>Patient Sets View</li>
<li>PostgreSQL Database Support</li>
<li>Workplace Find View</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-5">CORE-5</a>] - CRC build from source deposits i2b2Common-core.jar in wrong directory</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-70">CORE-70</a>] - I2b2 compilation of CRC Cell fails</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-74">CORE-74</a>] - Typo in i2b2_config_data.js of admin interface</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-81">CORE-81</a>] - No PATIENT_NUM in OBSERVATION_FACT_PK (conflict with documentation)</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>Architecture, design and messaging documents for the new Identity Management (IM) Cell.</li>
<li>Design documentation for the new Temporal Query Tool plug-in.</li>
<li>User guide for the new Temporal Query view.</li>
<li>Documentation for the new views (Patient Set, Patient Mapping, Managers Tool, and Find in Workplace).</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-8">CORE-8</a>] - Suggestions for improvements to installation documents
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-75">CORE-75</a>] - CRC_Design.pdf page numbers are broken, all page numbers are set to 1 of 1, 2 of 2, etc. instead of 1 of xx
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-78">CORE-78</a>] - Errors in I2B2 Hive Installation Guide v 1.7.0
</li>
</ul>
<h3>Tasks</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-45">CORE-45</a>] - Establish CRCLoader project (eclipse) from exiting ant build file failed
</li>
</ul>
<h2 id="rel1700chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7</h2>
<h3>New Features</h3>
<ul>
<li>
Temporal Queries (Modification made to existing Query Tool)
</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-40">WEBCLIENT-40</a>] - Webclient: documentation should state that php and curl are prerequisites for the webclient
</li>
</ul>
<h2 id="rel1700newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1700newFeatureDetails-tempQry">Temporal Queries</h3>
<p>The <b><i>temporal query</i></b> is a new type of query introduced in release 1.7. There are two components to these queries that make them a little more complex than the type of queries available prior to 1.7 (classic i2b2 queries).</p>
<p>The first component to these queries is the list of events defined by the user.</p>
<p>The second component is the relationship between the events. This relationship is referred to a Temporal Relationship, which is best described as how the different events relate in regards to the time in which the event(s) occurred.</p>
<p>Users can also define a patient or event population in which they wish to run the temporal query against. This step is optional and is not required in order to run the temporal query.</p>
<p>The process in which temporal queries are defined is slightly different in the i2b2 Web Client and the i2b2 Workbench. In the i2b2 Web Client the existing Query Tool view has been modified to accommodate Temporal Queries while a new view called Temporal Query Tool view has been created for the i2b2 Workbench.</p>
<p>The new Temporal Query Tool view and the modifications to the existing Query Tool view extend the query functionalities provided by the classic Query Tool view.</p>
<p>It is important to note that while the manner in which users setup a temporal query is different in each of the clients the overall functionality is the same.</p>
<p>The following two sections will describe how to run Temporal Queries in the i2b2 Web Client and the i2b2 Workbench.</p>
<h4>i2b2 Web Client: Temporal Queries</h4>
<p>In the i2b2 Web Client there are five basic steps in defining a <i>temporal query</i> in the <b>Query Tool view</b>.</p>
<ol>
<li>Change <i>Temporal Constraint</i> to <b>Define sequence of Events</b>.</li>
<li>Define <i>Population in which events occur</i> (optional step).</li>
<li>Define Events</li>
<li><i>Define order of events</i> (temporal relationships)</li>
<li>Run the query</li>
</ol>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>For detailed information about creating Temporal Queries please see the Temporal Query help file located on-line from within the i2b2 Web Client.
</td>
</tr>
</tbody>
</table>
</div>
<h6>Step 1: Change Temporal Constraint</h6>
<p>The first step is to change the Temporal Constraint to <i>Define sequence of Events</i>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-1.png" alt="Temporal Query - Define Sequence of Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 2: Define Population in which events occur</h6>
<p>Once you have changed the Temporal constraint to be <i>Define sequence of Events</i> a new <b>Page selection box</b> will appear below the Temporal Constraint section. The default page will be <b>Population in which events occur</b>. It is on this page you will define your population requirements.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-2.png" alt="Temporal Query - Define Population" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 3: Define Events</h6>
<p>The events are the first component of a temporal query. There are no restrictions on the number of events you wish to define. The only requirement is that you have to define at least two events.</p>
<p>To define the events simply click on the <i>Page selection box</i> and select <b>Event 1</b> from the drop-down list.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-3.png" alt="Temporal Query - Define Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The groups and constraints for the events work in the same manner as they did for a traditional i2b2 query. Simply drag the items you want to include in Event 1 to the appropriate groups.</p>
<p>Once you have added your items to the groups you can click on the <i>Page selection box</i> and select <b>Event 2</b> from the drop-down list. This will change the page to display the groups for Event 2.</p>
<p>If you need to add a third event you can click on the <b>New Event button</b> located next to the <i>Page selection box</i>.</p>
<h6>Step 4: Define Order of Events (Temporal Relationship)</h6>
<p>As stated earlier the second component of a temporal query is the relationship between the events (temporal relationship). In the i2b2 Web Client this is done on the <b>Define order of events page</b>, which is accessed by clicking on the <i>Page selection box</i> and selecting <b>Define order of events</b> from the drop-down list.</p>
<p>The page will display as follows:</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link"
href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-4.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-4.png" alt="Temporal Query - Define Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 5: Run Query</h6>
<p>In the Web Client running a query works the same regardless of whether or not it is a Temporal Query or a traditional i2b2 query. By clickin on the <b>Run Query button</b>, the i2b2 client will send the request to the i2b2 server which will run the query as defined.</p>
<h4>i2b2 Workbench: New Temporal Query Tool View</h4>
<p>In the i2b2 Workbench there are three pages or steps in defining and running a <i>temporal query</i> in the new <b>Temporal Query Tool view</b>.</p>
<ol>
<li>Page 1: Define Population</li>
<li>Page 2: Define Temporal Relationships</li>
<li>Page 3: Review and Submit Query</li>
</ol>
<h4>i2b2 Workbench: New Temporal Query Tool View</h4>
<h4>Define Date Constraints and Exclusions in Temporal Query Tool View</h4>
<h5>Defining the Date Constraints</h5>
<h5>Exclude Panel</h5>
<p>Each page as well as defining constraints is further defined in the next few sections.</p>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>For detailed information about using the Temporal Query Tool view, please see the help file for this view which is available on-line from within the i2b2 Workbench.
</td>
</tr>
</tbody>
</table>
</div>
<h6>Page 1: Define Population</h6>
<p>On this page you will define your population requirements.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-1.png" alt="Temporal Query - Define Population" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Page 2: Define Temporal Relationships</h6>
<p>As stated earlier there are two components to a <b><i>temporal query</i></b>; (1) List of events and (2) the relationship between the events.</p>
<p>The second page is where you will define both the events and their relationship.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-2.png" alt="Temporal Query - Define Relationships" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Page 3: Review and Submit</h6>
<p>On this page the name of the query will default and if you wish to rename it you can do so at this point. Whatever is entered here will be the name given to the query when it is run. In addition you can select the Analysis Types that you want when running the query.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-3.png" alt="Temporal Query - Submit" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h5>Defining Date Constraints and Exclusions in Temporal Query Tool View</h5>
<p>There are some minor differences in terminology or layout that needs to be noted in this release note.</p>
<h4>Defining the Date Constraints</h4>
<p>In the classic Query Tool view you can only define date constraints on the group / panel level. In the new Temporal Query TOol view you can now define a date constraint on either the query or group levels. If you define it on the query level it will default the same date constraint for all the groups and the date constraint on the panel level will not be available for selection.</p>
<p>If you want to define it on the panel level select <b>Group-Specific</b>. Go to the group you wish to define the constraint and click on the column that displays <i>No Date Constraints</i>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryDtConst.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryDtConst.png" alt="Temporal Query - Date Constraints" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h5>Exclude Panel</h5>
<p>The ability to exclude all items in a group does exist in the new Temporal Query Tool view. However, the method in which it is defined differs between the classic Query Tool view and the Temporal Query Tool view.</p>
<p>In the existing <b>Query Tool view ("Classic")</b> the exclusion constraint was defined by clicking on the button labeled <i>Exclude</i>.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclOld.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclOld.png" alt="Query Tool - Exclude" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>In the <b>Temporal Query Tool view (New)</b> the exclusion constraint was rolled into the window for defining the Occurrence constraint.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclNew.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclNew.png" alt="Temporal Query - Exclude" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The <i>Specify Occurrence Constraints</i> windows will open when you click on the box that displays the occurrence constraint. To set the exclusion constraint you need to select "= 0 (No Occurrences)" from the drop-down list.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryOccur.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryOccur.png" alt="Temporal Query - Occur Constraint" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The above option is equivalent to the <i>Exclude</i> feature in the classic Query Tool view.
</p>
<h3 id="rel1700newFeatureDetails-pqFilterUser">Previous Query: Filter list by user</h3>
<p>New in release 1.7 is the ability to filter the list of previous queries by the user who created the query. In the options dialog <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_options.png" alt="Options Icon" height="20" width="20" style="border: 0px solid black">)</span> window there is a new field called <b>Get previous queries for user</b>. The default is <i>all users</i> and can be changed to a specific user by clicking on the down arrow to display the drop-down list. Once you select the user and click on <b>OK</b>, the Previous Queries view will refresh and display only those previous queries created by the selected user.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqFilterByUser.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqFilterByUser.png" alt="Previous Queries - Filter by User" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>In i2b2 only managers are allowed to view queries for another user, therefore this feature is only available to those users who have the role of <b>MANAGER</b> defined for the project. If a user does not have the manager role then this field will be inactive and unavailable for selection.
</td>
</tr>
</tbody>
</table>
</div>
<h3 id="rel1700newFeatureDetails-pqSearch">Previous Query: Search Previous Queries View</h3>
<p>
In release 1.7 the ability to search the Previous Queries view has been added. The functionality is very similar to <i>Find Terms</i> view except it will search the <i>Previous Queries</i> view instead of <i>Navigate Terms</i> view. Users can search any of the three levels;
</p>
<ol>
<li>Previous Query (name)</li>
<li>Previous Query Result</li>
<li>Patient</li>
</ol>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqSearch.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqSearch.png" alt="Previous Queries - Search" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-pqPaging">Previous Query: Page through previous queries by date</h3>
<p>Users can now retrieve the next or previous grouping of previous queries by the date in which the query was created.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqPaging.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqPaging.png" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The <i>Previous button</i> <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/button_previous.png" alt="Previous Button" height="20" width="20" style="border: 0px solid black">)</span> will retrieve the group of previous queries that occur <b>prior</b> to the date displayed in the date / time field.</p>
<p>The <i>Next button</i> <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/button_next.png" alt="Next Button" height="20" width="20" style="border: 0px solid black">)</span> will retrieve the group of previous queries that occur <b>after</b> the date displayed in the date / time field.</p>
<h3>Identity Management Cell (IM)</h3>
<p>A new cell called the Identity Management (IM) Cell was developed in release 1.7. This new cell contains Protected Health Information (PHI), which can be used to identify patients. The IM cell is used to manage this PHI in a manner consistent with the HIPAA privacy rule. The patient data will be available only as a HIPAA defined "Limited Data Set" to most of the hive.</p>
<p>The full functionality of the IM cell will be developed in stages. The initial framework and key services are released as part of the 1.7 release. Some of the key features being released in 1.7 are:</p>
<ol>
<li>New tables to store identifiers from different sites, and patients that are included in a project.</li>
<li>Audit controls are implemented that are in compliance with the HIPAA privacy rules.</li>
<li>Services developed to set and validated an AES key for encrypting and decrypting patient MRNs in the IM cell.</li>
<li>Unencrypted patient identifiers sent in the PDO can be processed through the IM cell to retrieve all site IDs for the patient and project.</li>
</ol>
<p>In addition to the above features, the i2b2 Worbench (eclipse client) has two new views that were created to support the new IM cell. These new views, called <b>Patient Mapping</b> and <b>Admin Tool</b> are further defined in the following two sections called <i>Patient Mapping View</i> and <i>Admin Tool View</i>.</p>
<h3 id="rel1700newFeatureDetails-mgrsView">Managers Tool View</h3>
<p>The <b>Managers Tool</b> view was developed in release 1.7 and works in conjunction with the IM Cell. It currently has two main functions.</p>
<ol>
<li>Set and / or validate that the project key is defined in the IM Cell.</li>
<ul>
<li>The project key is used by the IM cell to decrypte the patient id"s that are encrypted.</li>
<li>The Set Key is used to define the key in the IM cell.</li>
<li>The Validate Key is used to verify the key is set.</li>
</ul>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>If you are using the IM cell and your patient identifiers are encyrpted the you need to set the Project key in the IM cell. It is important to note that if you restart your i2b2 server or in the case of the VM image restarting the virtual machine then you will need to re-enter the project key.
<br>
<br>The project key for the i2b2 demo project is: <b>i2b2demodatakey1</b>
<br>
<br>In the VM image you need to log into the i2b2 Workbench as the i2b2 Admin user.
<br>
<p class="i2b2-panel-list">User ID: i2b2
<br>Password: demouser</p>
</td>
</tr>
</tbody>
</table>
</div>
<li>View the audit information.</li>
<ul>
<li>As part of the IM cell an audit table was created to track when a patient in the IM cell was accessed. This new view allows Project Managers or Administrators to run a report to see that audit information. The report can be run for a particular user, patient, or all audit information for the project you are logged into.</li>
</ul>
</ol>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_mgrsTool.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_mgrsTool.png" alt="Managers Tool View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-ptSetsView">Patient Sets View</h3>
<p>In release 1.7 a new view called <b>Patient Sets</b> was created. This new view will display a list of <i>Patient sets</i> that were created when a query was run. It is similar to the Previous Queries view except it only displays the patient sets and not the previous query or other result sets (i.e. Encounter sets, Number of patients, etc).</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-1.png" alt="Patient Sets View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The patient sets can be expanded to display a list of patients.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-2.png" alt="Patient Sets View Expanded" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>Users can drag an entire patient set or a single patient to other views in the i2b2 Workbench.</p>
<p>Users can also perform a search in which they can search by the name of the patient set or for a list of patient sets that contain a specific patient.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-3.png" alt="Patient Sets View Search" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-workFindView">Workplace Find View</h3>
<p>A new view called <b>Find in Workplace</b> was created in release 1.7. This view is very similar to the <i>Find Terms</i> view except it will search the <i>Workplace</i> view instead of the <i>Navigate Terms</i> view.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_workFind.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_workFind.png" alt="Workplace Find View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-jumpToTerm">Find Terms: New feature called "Jump to Term in Tree"</h3>
<p>A new feature called <b>Jump to Term in Tree</b> has been added to the <i>Find Terms</i> view. Users can now easily jump directly to a term in the <i>Navigate Terms</i> view from the <i>Find Terms</i> view.</p>
<p>Once a term is found in the <i>Find Terms</i> view the user can click on the term using the <i>right mouse button</i> to display the pop-up menu. Selecting "Jump to Term in Tree" from the pop-up menu will bring the <i>Navigate Terms</i> view into focus and the hierarchical tree will automatically open to the location of the term selected in the <i>Find Terms</i> view.</p>
<h3>OpenEMPISupport</h3>
<p>OpenEMPI is an open source Enterprise Master Patient Index (EMPI) which is developed and supported by another community. The i2b2 IM cell has been developed to allow communication with OpenEMPI for those sites that choose to use it as their patient repository.</p>
<p>For additional information on OpenEMPI please see their website by going to the following location: <a href="https://openempi.kenai.com/">https://openempi.kenai.com/</a>
</p>
<h3 id="rel1700newFeatureDetails-postgresql">PostgreSQL Database Support</h3>
<p>The ability to use a PostgreSQL database as an i2b2 database has been added to release 1.7. Both the create and insert data database scripts for PostgreSQL are included in this release.</p>
<h3 id="rel1700newFeatureDetails-newImTables">Data: New Tables created for the IM Cell</h3>
<p>The following new tables were created as part of the new IM cell.</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">Table Name</th>
<th class="i2b2-th">Description</th>
</tr>
<tr>
<td class="i2b2-td">IM_MPI_DEMOGRAPHICS</td>
<td class="i2b2-td">Contains General demographic information for the patients.</td>
</tr>
<tr>
<td class="i2b2-td">IM_MPI_MAPPING</td>
<td class="i2b2-td">Maps the patient"s <i>i2b2 number</i> and the <i>local MRN</i>.</td>
</tr>
<tr>
<td class="i2b2-td">IM_PROJECT_SITES</td>
<td class="i2b2-td">Contains information about the different sites (Source Systems).</td>
</tr>
<tr>
<td class="i2b2-td">IM_PROJECT_PATIENTS</td>
<td class="i2b2-td">Stores the patients that are part of a project(s).</td>
</tr>
<tr>
<td class="i2b2-td">IM_AUDIT</td>
<td class="i2b2-td">Stores the audit details of patients accessed in the IM cell. This includes; the user, site, and project requesting the access as well as the date in which it was accessed.</td>
</tr>
</table>
<h3 id="rel1700newFeatureDetails-dataNewColumns">Data: New Columns added to support IM cell</h3>
<p>A new column called <b>Project_ID</b> has been added to both the <b>PATIENT_MAPPING</b> and <b>ENCOUNTER_MAPPING</b> tables in the crc. The PROJECT_ID was added to support the IM cell. It will allow sites to track which project a patient is part of.</p>
<h3 id="rel1700newFeatureDetails-dataPtMap">Data: Improved Patient Mapping Data</h3>
<p>The <b>PATIENT_MAPPING</b> table in the CRC has been updated to include the following:</p>
<ul>
<li>Mappings of existing patients to multiple site MRNs.</li>
<li>Project IDs added to patients.</li>
</ul>
<p>Demo data has been added to all of the new IM tables except the AUDIT table. This IM data was added to provide examples for using the new IM cell.</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091522/icon_important.png" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Important</b>
<br>The mapping information added to the CRC and IM tables is strictly for demonstration purposes and does NOT contain real patient information.</td>
</tr>
</table>
</div>
<h3 id="rel1700newFeatureDetails-postgresqlScripts">New PostgreSQL Database Scripts</h3>
<p>The i2b2 database scripts have been updated to include the table creation and data insert scripts for a PostgreSQL database.</p>
<hr>
<h1>Licensing</h1>
<p>The i2b2 source code is licensed under the i2b2 Software License 2.1. This includes but is not limited to all code in the edu.harvard.i2b2.* package namespace.</p>
<h1>Trademarks</h1>
<p>Microsoft, Windows, Windows 7, Windows Server 2003 and 2008 are either registered trademarks or trademarks of Microsoft Corporation in the United States and / or other countries.</p>
<p>Mac OS is a registered trademark of Apple Inc.</p>
<p>Eclipse Galileo is a registered trademark of the Eclipse Foundation, Inc.</p>
<p>All other trademarks are the property of their respective owners.</p>
</body>
</html> |
Include Page | ||||
---|---|---|---|---|
|