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

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.08
    • Component/s: None
    • Labels:
      None
    • Rank:
      0|i002wf:
    • Affects View/s:
      Query Tool
    • i2b2 Feature/s:
      Queries
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      All databases
    • Reproduction Notes:
      Run a query to invoke the GetTermInfo message by the CRC.
    • Developer Notes:
      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)..
    • Testing Notes:
      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

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code