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

Erroneous results on search by value with BETWEEN

Details

    • Bug
    • Status: New
    • Major
    • Resolution: Unresolved
    • None
    • TBD
    • None
    • None
    • Find (Previous Queries)

    Description

      In the client search by value, for the use case of searching for value between 4 and 6,
       
      the generated SQL:
      - for BETWEEN SEARCHES: (valtype_cd = 'N' AND nval_num BETWEEN 4 and 6 AND tval_char ='E'

      does not handle OBSERVATION_FACTs where numeric results are stored as '>=4' or '=<6'.
      For correct results, I think that TVAL_CHAR IN ('E', 'GE', 'LE') should be the generated code

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          campbell@unmc.edu James Campbell created issue -
          mem61 Mike Mendis made changes -
          Field Original Value New Value
          Affects Version/s 1.7.11 [ 10703 ]
          mem61 Mike Mendis made changes -
          Fix Version/s 1.7.11 [ 10703 ]
          mem61 Mike Mendis made changes -
          Fix Version/s 1.7.12 [ 10901 ]
          Fix Version/s 1.7.11 [ 10703 ]
          jklann Jeffrey Klann made changes -
          Component/s CRC Cell [ 10049 ]
          Fix Version/s 1.7.12 [ 10901 ]
          Key CORE-303 IIC-2
          Affects Version/s 1.7.11 [ 10703 ]
          Workflow i2b2 Issues Workflow [ 11872 ] Software Simplified Workflow for Project IIC [ 11996 ]
          Project i2b2 Core Software [ 10034 ] i2b2 Issues (Community-submitted) [ 10730 ]
          Status New [ 10000 ] To Do [ 10006 ]
          mem61 Mike Mendis made changes -
          Key ISSUE-2 CORE-355
          Workflow Software Simplified Workflow for Project IIC [ 11996 ] i2b2 Issues Workflow [ 12062 ]
          Project i2b2 Issues (Community-submitted) [ 10730 ] i2b2 Core Software [ 10034 ]
          Status To Do [ 10006 ] New [ 10000 ]
          mem61 Mike Mendis made changes -
          Fix Version/s 1.7.12 [ 10901 ]
          rm302 Reeta Metta made changes -
          Assignee Mike Mendis [ mem61 ]
          rm302 Reeta Metta made changes -
          Fix Version/s 1.7.13 [ 10902 ]
          rm302 Reeta Metta made changes -
          Fix Version/s 1.7.12 [ 10901 ]
          jklann Jeffrey Klann added a comment -
          Jim, we don't think this is an error. If you have a fact that is, for example <=4.9, the value could actually be 3. Therefore, if you search for values between 4 and 6, you would not expect that fact to be counted in the results. Do you agree, or are we missing something?
          jklann Jeffrey Klann added a comment - Jim, we don't think this is an error. If you have a fact that is, for example <=4.9, the value could actually be 3. Therefore, if you search for values between 4 and 6, you would not expect that fact to be counted in the results. Do you agree, or are we missing something?
          rm302 Reeta Metta made changes -
          Fix Version/s TBD [ 11005 ]
          Fix Version/s 1.7.13 [ 10902 ]

          People

            mem61 Mike Mendis
            campbell@unmc.edu James Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: