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

Cant build timeline when db is postgres

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.7.09
    • None
    • None
    • Timeline View
    • i2b2 Core
    • PostgreSQL
    • Hide
      This was commited along with a much larger commit for OMOP processing (CORE-240) ... You may want to test them at same time
      Show
      This was commited along with a much larger commit for OMOP processing ( CORE-240 ) ... You may want to test them at same time

    Description

      The sql that is built when a db is postgres is invalid.

      The reason for this is that the sql is built in two parts: The first part combines postgres with oracle workflow;' the second combines postgres with sqlserver flow. The result is a query that is half oracle; half sqlserver.

      The solution is to default postgres sql construction to the oracle flow.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips created issue -
          lcp5 Lori Phillips made changes -
          Field Original Value New Value
          Assignee Lori Phillips [ lcp5 ]
          lcp5 Lori Phillips made changes -
          Affects Database/s PostgreSQL [ 10188 ]
          Affects View/s Timeline View [ 10053 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          jmd86 Janice Donahoe made changes -
          Status New [ 10000 ] Open [ 1 ]
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Developer Notes This was commited along with a much larger commit for OMOP processing (CORE-240) ... You may want to test them at same time
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          lcp5 Lori Phillips made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.09 [ 10306 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe added a comment -
          This issue has been fixed and will be included in release 1.7.09.

          jmd86 Janice Donahoe added a comment - This issue has been fixed and will be included in release 1.7.09.
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            lcp5 Lori Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: