[CORE-279] Single panel exclusion query returns error Created: 14/Nov/17 Updated: 02/Feb/18 Resolved: 29/Nov/17 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | CRC Cell |
| Affects Version/s: | 1.7.09b |
| Fix Version/s: | 1.7.09c |
| Type: | Bug | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Lori Phillips |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Affects View/s: |
Query Tool
|
| i2b2 Feature/s: |
Constraints - Exclusion
|
| Affects Database/s: |
All databases, Oracle, PostgreSQL, SQL Server
|
| Participant/s: |
| Description |
|
When you run a single panel query that is marked for exclusion an error is returned from the server.
IMPORTANT: This error only happens when the following parameter in the crc.properties file is set to true: # DERIVED FACT TABLE queryprocessor.multifacttable=true If the above parameter is set to false, meaning you are not using multiple facts, then you will not encounter this error. |
| Comments |
| Comment by Janice Donahoe [ 29/Nov/17 ] |
| Tested to be included in 1.7.09c and it appears to be working correctly. As part of the testing scenarios, the fix was tested with the multifacttable parameter turned on (value=true) and turned off (value=false). In addition, all types of queries in which exclusions could be used were re-tested to verify they are still working correctly. No issues were found during the testing process. |