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

Queries built using patient sets create incorrect SQL

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • None
    • TBD
    • None
    • None
    • Query Tool
    • Filters - Patient Sets
    • Oracle
    • All Web Browsers

    Description

      Case:

      User creates a patient set. User then uses that patient set as a filter on a subsequent query. The following SQL is generated and produces an error.

      =====
      select f.patient_num
      from i2b2crc.observation_fact f
      where
      f. patient_num IN (select patient_num from i2b2crc.qt_patient_set_collection where result_instance_id = )
      group by f.patient_num
      =====
      This fails because the where clause is incomplete.

      Attachments

        Activity

          People

            mem61 Mike Mendis
            akvallejos Andrew Vallejos
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: