Details
-
Bug
-
Status: New
-
Major
-
Resolution: Unresolved
-
None
-
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
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