Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-98

Patient breakdown result types are not working when querying a PostgreSQL database

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.00, 1.7.01
    • 1.7.02
    • CRC Cell
    • None
    • PostgreSQL database
    • Query Tool
    • Patient Breakdowns, Queries
    • Tested with the latest build and PostgreSQL database (bamboo) and it appears to be working correctly.

    Description

      The query result types for patient breakdowns do not appear to be working correctly when the i2b2 query is run against a PostgreSQL database. A count of zero will be returned for each item.

      Example: Gender breakdown will display as following in the Query Status view.

      Female: 0
      Male: 0
      Unknown: 0

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Workflow classic default workflow [ 10251 ] i2b2 Issues [ 10313 ]
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10313 ] i2b2 Issues Workflow [ 10447 ]
          mem61 Mike Mendis made changes -
          Fix Version/s 1.7.02 [ 10091 ]
          mem61 Mike Mendis made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Component/s CRC Cell [ 10049 ]
          Component/s CRC Cell [ 10000 ]
          Fix Version/s 1.7.02 [ 10155 ]
          Fix Version/s 1.7.02 [ 10091 ]
          Key LEOPARD-153 CORE-98
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.7.01 [ 10154 ]
          Affects Version/s 1.7.00 [ 10153 ]
          Affects Version/s 1.7.00 [ 10081 ]
          Affects Version/s 1.7.01 [ 10090 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Affects View/s Query Tool [ 10077 ]
          Build Number/s (Testing) 1.7.02.0005
          Testing Notes Tested with the latest build and PostgreSQL database (bamboo) and it appears to be working correctly.
          i2b2 Feature/s Patient Breakdowns,Queries [ 10082, 10081 ]
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Build Number (Fixed) 1.7.02.0005
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: