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 created issue -
          lcp5 Lori Phillips made changes -
          Field Original Value New Value
          Affects Database/s All databases [ 10219 ]
          Affects View/s Query Tool [ 10077 ]
          Reproduction Notes Run a query to invoke the GetTermInfo message by the CRC.
          Assignee Lori Phillips [ lcp5 ]
          i2b2 Feature/s Queries [ 10081 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Priority Major [ 3 ] Minor [ 4 ]
          Status New [ 10000 ] Open [ 1 ]
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Developer Notes To improve performance on GetTermInfo ...
          Assuming a clean build, test this by having the CRC invoke a GetTermInfo
          (run a query)..
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.08 [ 10204 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes 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.

          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: