[CORE-125] Query using concepts from the clinical trials folder always returns zero patients Created: 27/Jun/14 Updated: 01/Jul/14 Resolved: 01/Jul/14 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | 1.7.00 |
| Fix Version/s: | 1.7.02 |
| Type: | Bug | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Rank: | 0|i00073: |
| i2b2 Sponsored Project/s: |
i2b2 Core
|
| i2b2 Related Project/s: |
Clinical Trials
|
| Affects Database/s: |
All databases
|
| Reproduction Notes: | Can be reproduced in all i2b2 environments using the i2b2 demo data. |
| Developer Notes: | The problem is the clinical trial concepts are missing from the CONCEPT_DIMENSION table. The data from the BIRN Metadata table have been added to CONCEPT_DIMENSION table |
| Testing Notes: | Tested and appears to be working correctly. Tested in all three supported databases (Oracle, PostgreSQL, and SQLServer). |
| Participant/s: |
| Description |
|
When running a query using any of the concepts from the clinical trials folder (demo data) zero patients are always returned.
|