Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 1.7.06
-
Fix Version/s: 1.7.07
-
Component/s: Web Client
-
Labels:None
-
Affects View/s:Timeline View
-
i2b2 Sponsored Project/s:i2b2 Web Client
-
Affects Database/s:All databases
-
Affects Web Browser/s:All Web Browsers
-
Reproduction Notes:
-
Testing Notes:
Description
Database: MS SQL Server
i2b2 Web Client v1.7.06
I am not sure whether this problem is actually with the web client or possible the underling SQL queries
I run a query which has 6 groups. I request the following query results: Patient Set, Number of Patients and Timeline.
There are multiple problems found in the Timeline detail information
1) detail for a time point doesn't match the time line row title.
2) detail for a time point contains multiple values rather then the values for that specific time point.
I have attached screen shots of the above problems.
TimeLineConcepts.jpg - shows the concepts generated by the query.
TimePointDetail.jpg. - Shows the detail for time point 1/17/1995. The time point is in row named "Insulin" the observation details shows a concept_ID of VISIT|LOC:300
TimePointDetail2.jpg - Shows the detail for time pint 1/17/1995. The time point is in row named "10-17 years old", the observation details shows concept_id of ICD9:250.00
TimePointMultipleValues.jpg - Shows the detail for time point 5/17/2007. The observation details shows the values for 5 time points which appear to be all strung together. The start/end date does not appear to be correct for the time point. The start_date is later than the end_date.
Please let me know if you require additional information.
Tom Graf
graf.thomas@mayo.edu
i2b2 Web Client v1.7.06
I am not sure whether this problem is actually with the web client or possible the underling SQL queries
I run a query which has 6 groups. I request the following query results: Patient Set, Number of Patients and Timeline.
There are multiple problems found in the Timeline detail information
1) detail for a time point doesn't match the time line row title.
2) detail for a time point contains multiple values rather then the values for that specific time point.
I have attached screen shots of the above problems.
TimeLineConcepts.jpg - shows the concepts generated by the query.
TimePointDetail.jpg. - Shows the detail for time point 1/17/1995. The time point is in row named "Insulin" the observation details shows a concept_ID of VISIT|LOC:300
TimePointDetail2.jpg - Shows the detail for time pint 1/17/1995. The time point is in row named "10-17 years old", the observation details shows concept_id of ICD9:250.00
TimePointMultipleValues.jpg - Shows the detail for time point 5/17/2007. The observation details shows the values for 5 time points which appear to be all strung together. The start/end date does not appear to be correct for the time point. The start_date is later than the end_date.
Please let me know if you require additional information.
Tom Graf
graf.thomas@mayo.edu