[CORE-116] On Amazon Demo site, the Visit Detail AGE does not work Created: 30/May/14 Updated: 01/Jul/14 Resolved: 04/Jun/14 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | 1.7.01 |
| Fix Version/s: | 1.7.02 |
| Type: | Bug | Priority: | Major |
| Reporter: | Shawn Murphy | Assignee: | Mike Mendis |
| 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: |
Queries
|
| i2b2 Sponsored Project/s: |
i2b2 Core
|
| Affects Web Browser/s: |
Chrome, Firefox, Internet Explorer, Safari
|
| Reproduction Notes: | I am not able to reproduce it in the i2b2 development environment but I am able to reproduce it on the public webclient (i2b2.org site).
The problem may be with the data in the metadata tables. The database/schema information prefacing the calculations may be incorrect. |
| Participant/s: |
| Description |
|
An error is returned when running a query in which one of the concepts is an "Age at visit" term.
|
| Comments |
| Comment by Mike Mendis [ 04/Jun/14 ] |
| Updated the demo site, this is a case where the c_dimcode is hardcoded with a specific SQL statement, and in this case has i2b2demodata. as the schema name. On the amazon database the schema was not i2b2demodata |