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

Single panel exclusion query returns error

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.09b
    • 1.7.09c
    • CRC Cell
    • None
    • Query Tool
    • Constraints - Exclusion
    • All databases, Oracle, PostgreSQL, SQL Server

    Description

      When you run a single panel query that is marked for exclusion an error is returned from the server.

      IMPORTANT: This error only happens when the following parameter in the crc.properties file is set to true:

      # DERIVED FACT TABLE
      queryprocessor.multifacttable=true


      If the above parameter is set to false, meaning you are not using multiple facts, then you will not encounter this error.

      Attachments

        Activity

          jmd86 Janice Donahoe added a comment -
          Tested to be included in 1.7.09c and it appears to be working correctly. As part of the testing scenarios, the fix was tested with the multifacttable parameter turned on (value=true) and turned off (value=false). In addition, all types of queries in which exclusions could be used were re-tested to verify they are still working correctly. No issues were found during the testing process.
          jmd86 Janice Donahoe added a comment - Tested to be included in 1.7.09c and it appears to be working correctly. As part of the testing scenarios, the fix was tested with the multifacttable parameter turned on (value=true) and turned off (value=false). In addition, all types of queries in which exclusions could be used were re-tested to verify they are still working correctly. No issues were found during the testing process.

          People

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

            Dates

              Created:
              Updated:
              Resolved: