Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
1.7.06
-
None
-
Timeline View
-
i2b2 Web Client
-
All databases
-
All Web Browsers
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