[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.
Generated at Fri Jan 21 12:19:00 UTC 2022 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.