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

Change GetTermInfo from a like clause to an equal clause

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.7.08
    • None
    • None
    • Query Tool
    • Queries
    • i2b2 Core
    • All databases
    • Run a query to invoke the GetTermInfo message by the CRC.
    • Hide
      To improve performance on GetTermInfo ...
      Assuming a clean build, test this by having the CRC invoke a GetTermInfo
      (run a query)..
      Show
      To improve performance on GetTermInfo ... Assuming a clean build, test this by having the CRC invoke a GetTermInfo (run a query)..
    • Hide
      TEST STATUS: Completed
      COMPLETION DATE: 08/10/2016

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      TEST DATE: 08/10/2016
      TESTED BY: Janice Donahoe
      BUILD NUMBER: 1.7.08.0001
      TEST STATUS: Passed


      CLIENTS TESTED:
           i2b2 Web Client

      ENVIRONMENTS TESTED:
           Browsers: Not applicable for this test
           Databases: Oracle and SQL Server
           Client OS: Windows and Macintosh


      TEST COMMENTS:
      Tested with the latest build (1.7.08.0001) and it appears to be working correctly. I have not had any problems running queries, dragging and dropping terms or using previous queries.

      Show
      TEST STATUS: Completed COMPLETION DATE: 08/10/2016 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ TEST DATE: 08/10/2016 TESTED BY: Janice Donahoe BUILD NUMBER: 1.7.08.0001 TEST STATUS: Passed CLIENTS TESTED:      i2b2 Web Client ENVIRONMENTS TESTED:      Browsers: Not applicable for this test      Databases: Oracle and SQL Server      Client OS: Windows and Macintosh TEST COMMENTS: Tested with the latest build (1.7.08.0001) and it appears to be working correctly. I have not had any problems running queries, dragging and dropping terms or using previous queries.

    Description

      This is a performance enhancement to change the sql statement from a
      "like (c_fullname)" to "= (c_fullname)

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips added a comment -
          Assuming a clean build, test this by having the CRC invoke a GetTermInfo
          (run a query)..
          lcp5 Lori Phillips added a comment - Assuming a clean build, test this by having the CRC invoke a GetTermInfo (run a query)..
          jmd86 Janice Donahoe added a comment -
          This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe added a comment - This change was included in version 1.7.08, which was released on 10/07/2016.

          People

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

            Dates

              Created:
              Updated:
              Resolved: