Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-138

Timeline bugs

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.7.06
    • 1.7.07
    • Web Client
    • None
    • Timeline View
    • i2b2 Web Client
    • All databases
    • All Web Browsers
    • Hide
      I was able to reproduce this in the i2b2 Demo site which is currently 1.7.06. The following steps were taken to reproduce the issue.

      1. Log into the i2b2 demo site.
      2. Add the following concepts to the query tool.

      Group / Panel 1 = Male
      Group / Panel 2 = Black, Hispanic, White
      Group / Panel 3 = Hypertensive disease
      Group / Panel 4 = Ischemic heart disease

      3. Run the query making sure Timeline is selected.

      4. Once the timeline renders notice only the first three concepts appear in the timeline (Black, Hispanic, and Hypertensive disease). The other concepts do not appear as a "line item".

      5. Notice the first DEMO patient (1000000026) has the concept "Black" and when you scroll over and hover over the first tic mark on that line it is for a hypertensive disease.

      - if you go to the next line which is supposed to be Hispanic, the items on this line are for Ischemic heart disease.

      - if you to the last line, which is supposed to be Hypertensive disease, the item on this line is for "Male".


      WHAT APPEARS TO BE HAPPENING:
      There are a few things I have noticed happening:

      1. The timeline will display only a few of the items and which ones appear are determined by the order they appear on the Specify data tab (which is alphabetically).

      2. If the first item is not returned in the XML message all the tic marks are thrown off on the timeline. They will move up a row on the timeline but the label that appears is still displaying the item that is missing data.

      3. In the demo data there is an issue with race's not being returned in the xml. This may be a setup issue in that we do not have races in the observation_fact table. They may only exist in the patient_dimension table. This will be further evaluated and if an issue is found then a new JIRA issue will be entered to track it.

      NOTE: I tested this in the workbench and the problem does not occur; it is only a problem in the Web Client.

      Show
      I was able to reproduce this in the i2b2 Demo site which is currently 1.7.06. The following steps were taken to reproduce the issue. 1. Log into the i2b2 demo site. 2. Add the following concepts to the query tool. Group / Panel 1 = Male Group / Panel 2 = Black, Hispanic, White Group / Panel 3 = Hypertensive disease Group / Panel 4 = Ischemic heart disease 3. Run the query making sure Timeline is selected. 4. Once the timeline renders notice only the first three concepts appear in the timeline (Black, Hispanic, and Hypertensive disease). The other concepts do not appear as a "line item". 5. Notice the first DEMO patient (1000000026) has the concept "Black" and when you scroll over and hover over the first tic mark on that line it is for a hypertensive disease. - if you go to the next line which is supposed to be Hispanic, the items on this line are for Ischemic heart disease. - if you to the last line, which is supposed to be Hypertensive disease, the item on this line is for "Male". WHAT APPEARS TO BE HAPPENING: There are a few things I have noticed happening: 1. The timeline will display only a few of the items and which ones appear are determined by the order they appear on the Specify data tab (which is alphabetically). 2. If the first item is not returned in the XML message all the tic marks are thrown off on the timeline. They will move up a row on the timeline but the label that appears is still displaying the item that is missing data. 3. In the demo data there is an issue with race's not being returned in the xml. This may be a setup issue in that we do not have races in the observation_fact table. They may only exist in the patient_dimension table. This will be further evaluated and if an issue is found then a new JIRA issue will be entered to track it. NOTE: I tested this in the workbench and the problem does not occur; it is only a problem in the Web Client.
    • Hide
      TEST STATUS: Completed
      COMPLETION DATE: 12/30/2015

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      Test Date: 12/30/2015
      Build Number:1.7.07
      Test Status: Completed (Passed Testing)
      Clients Tested :
           i2b2 Web Client
           Environments Tested :
           Browsers: Chrome, Firefox, Internet Explorer, and Safari
           Databases: Not applicable for this test
           Client OS: Windows, Mac
      Test Comments:
      Working as expected
      ISSUES FOUND: query run as query-in-query containing unsupported concepts does not draw the timeline. will be logged as separate issue
      Show
      TEST STATUS: Completed COMPLETION DATE: 12/30/2015 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Test Date: 12/30/2015 Build Number:1.7.07 Test Status: Completed (Passed Testing) Clients Tested :      i2b2 Web Client      Environments Tested :      Browsers: Chrome, Firefox, Internet Explorer, and Safari      Databases: Not applicable for this test      Client OS: Windows, Mac Test Comments: Working as expected ISSUES FOUND: query run as query-in-query containing unsupported concepts does not draw the timeline. will be logged as separate issue

    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

      Attachments

        1. TimeLineConcepts.jpg
          TimeLineConcepts.jpg
          54 kB
        2. TimePointDetail.jpg
          TimePointDetail.jpg
          92 kB
        3. TimePointDetail2.jpg
          TimePointDetail2.jpg
          83 kB
        4. TimePointMultipleValues.jpg
          TimePointMultipleValues.jpg
          127 kB

        Activity

          Ascending order - Click to sort in descending order
          nich Nich added a comment -
          The issue seems to be that the timeline is having trouble with PATIENT_DIMENSION concepts. That is, out of the concepts that Thomas selected, the following ones (I am assuming) are going against the patient dimension table:

          0-9 years old
          10-17 years old
          Arizona
          Rochester

          The four concepts above should really not display in the timeline at all, but the names are manifesting themselves OVER the remaining four valid concepts:

          Diabetes
          Hemoglobic A1c
          Insulin
          Metformin

          Therefore, the labels are wrong and should really have the concept names of Diabetes, Hemoglobin, etc...

          This can be reproduced by just running looking at a timeline for one patient dimension concept such as "10-17 years old" and see that the timeline has no results. Then add a random Diagnosis, and see that the timeline is populated but with the wrong label of "10-17 years old"
          nich Nich added a comment - The issue seems to be that the timeline is having trouble with PATIENT_DIMENSION concepts. That is, out of the concepts that Thomas selected, the following ones (I am assuming) are going against the patient dimension table: 0-9 years old 10-17 years old Arizona Rochester The four concepts above should really not display in the timeline at all, but the names are manifesting themselves OVER the remaining four valid concepts: Diabetes Hemoglobic A1c Insulin Metformin Therefore, the labels are wrong and should really have the concept names of Diabetes, Hemoglobin, etc... This can be reproduced by just running looking at a timeline for one patient dimension concept such as "10-17 years old" and see that the timeline has no results. Then add a random Diagnosis, and see that the timeline is populated but with the wrong label of "10-17 years old"
          jmd86 Janice Donahoe added a comment - - edited
          On 01/22/2016, the 1.7.07 Release was made available at the following locations.

          https://www.i2b2.org/software/
           - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

          https://github.com/i2b2
           - source code has been tagged with v1.7.07.
          jmd86 Janice Donahoe added a comment - - edited On 01/22/2016, the 1.7.07 Release was made available at the following locations. https://www.i2b2.org/software/  - zip files for release 1.7.07 are available on this site. This includes both the code and documentation. https://github.com/i2b2  - source code has been tagged with v1.7.07.

          People

            jmd86 Janice Donahoe
            m094076 Thomas Graf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: