Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
All environments (Firefox, I.E., Safari)
-
Query Tool
-
Constraints - Value
-
Chrome, Firefox, Internet Explorer, Safari
Description
Zero patients are always returned when the query contains a value constraint for a text (enumerated) value. The problem is the single quotes are missing from the xml message that is sent to the CRC.
Example of current xml for <constrain_by_value>:
<constrain_by_value>
<value_type>TEXT</value_type>
<value_constraint>(ADEQUATE)</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
In the above example you will notice the single quotes are missing around the value of ADEQUATE.
Here is what the same xml should look like:
<constrain_by_value>
<value_type>TEXT</value_type>
<value_constraint>('ADEQUATE')</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
NOTE: This is only an issue in the webclient. Queries with text value constraints are working correctly in the workbench (eclipse client).
Example of current xml for <constrain_by_value>:
<constrain_by_value>
<value_type>TEXT</value_type>
<value_constraint>(ADEQUATE)</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
In the above example you will notice the single quotes are missing around the value of ADEQUATE.
Here is what the same xml should look like:
<constrain_by_value>
<value_type>TEXT</value_type>
<value_constraint>('ADEQUATE')</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
NOTE: This is only an issue in the webclient. Queries with text value constraints are working correctly in the workbench (eclipse client).