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