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

CRC_cntrl_QryTool.js adds quotes to enumerated text values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.5.00
    • 1.6.00-RC2
    • CRC Cell
    • None
    • Rank:
      0|i00167:
    • Constraints - Value, Queries

    Description

      Query-by-value fails to find observation-facts because an quotes are inserted into the SQL where clause. For example, rather than "where tval_char = 'Malignant'" the SQL is generated as "where tval_char = '"Malignant"'

      The fix is to remove the quotes from line 518:

      sEnum = '("'+sEnum+'")';

      remove extra quotes -- change lin e 518 to

      sEnum = '('+sEnum+')';

      Attachments

        Activity

          People

            mem61 Mike Mendis
            jwlondon Jack London
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: