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

Cant build timeline when db is postgres

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.09
    • Component/s: None
    • Labels:
      None
    • Rank:
      0|i00373:
    • Affects View/s:
      Timeline View
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      PostgreSQL
    • Developer Notes:
      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

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code