Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.5.2
-
None
-
Query Tool
-
Constraints - Value
Description
The client is sending two value_types, when it should be only one
<value_type>ENUM</value_type>
<value_type>TEXT</value_type>
We were using Query & Analysis tool web client v1.4. Query-by-value worked for this version. We then upgraded to v1.5 and Query-by-value no longer worked.
Below is the i2b2 request:
****************************************************************************
<ns6:request xmlns:ns2="http://www.i2b2.org/xsd/hive/pdo/1.1/" xmlns:ns4="http://www.i2b2.org/xsd/cell/crc/psm/1.1/" xmlns:ns3="http://www.i2b2.org/xsd/cell/crc/pdo/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/plugin/" xmlns:ns6="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/">
<message_header>
<proxy>
<redirect_url>http://i2b2-tmp.kcc.tju.edu:8080/i2b2/rest/QueryToolService/request</redirect_url>
</proxy>
<sending_application>
<application_name>i2b2_QueryTool</application_name>
<application_version>0.2</application_version>
</sending_application>
<sending_facility>
<facility_name>PHS</facility_name>
</sending_facility>
<receiving_application>
<application_name>i2b2_DataRepositoryCell</application_name>
<application_version>0.2</application_version>
</receiving_application>
<receiving_facility>
<facility_name>PHS</facility_name>
</receiving_facility>
<security>
<domain>i2b2dev</domain>
<username>i2b2</username>
<password token_ms_timeout="1800000" is_token="true">SessionKey:Twn2JOF5QL44TXZJaAcD</password>
</security>
<message_type>
<message_code>Q04</message_code>
<event_type>EQQ</event_type>
</message_type>
<message_control_id>
<message_num>uOAeIN8hvmZ4MR9Y1J317</message_num>
<instance_num>0</instance_num>
</message_control_id>
<processing_id>
<processing_id>P</processing_id>
<processing_mode>I</processing_mode>
</processing_id>
<accept_acknowledgement_type>messageId</accept_acknowledgement_type>
<project_id>demo</project_id>
</message_header>
<request_header>
<result_waittime_ms>180000</result_waittime_ms>
</request_header>
<message_body>
<ns4:psmheader>
<user group="demo" login="i2b2">i2b2</user>
<patient_set_limit>0</patient_set_limit>
<estimated_time>0</estimated_time>
<request_type>CRC_QRY_runQueryInstance_fromQueryDefinition</request_type>
</ns4:psmheader>
<ns4:request xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns4:query_definition_requestType">
<query_definition>
<query_name>BLADDER@16:06:12</query_name>
<specificity_scale>0</specificity_scale>
<panel>
<panel_number>1</panel_number>
<invert>0</invert>
<total_item_occurrences>1</total_item_occurrences>
<item>
<hlevel>4</hlevel>
<item_name>BLADDER</item_name>
<item_key>\\TJUH_BIOSPECIMEN\Biospecimen\Frozen Specimens\A19\BLADDER\</item_key>
<tooltip>\Biospecimen\Specimen Type\Frozen\</tooltip>
<class>ENC</class>
<constrain_by_date>
</constrain_by_date>
<item_icon>FA</item_icon>
<item_is_synonym>false</item_is_synonym>
<constrain_by_value>
<value_type>ENUM</value_type>
<value_type>TEXT</value_type>
<value_constraint>("Malignant")</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
</item>
</panel>
</query_definition>
<result_output_list><result_output priority_index="1" name="patient_count_xml" /></result_output_list>
</ns4:request>
</message_body>
****************************************************************************
<value_type>ENUM</value_type>
<value_type>TEXT</value_type>
We were using Query & Analysis tool web client v1.4. Query-by-value worked for this version. We then upgraded to v1.5 and Query-by-value no longer worked.
Below is the i2b2 request:
****************************************************************************
<ns6:request xmlns:ns2="http://www.i2b2.org/xsd/hive/pdo/1.1/" xmlns:ns4="http://www.i2b2.org/xsd/cell/crc/psm/1.1/" xmlns:ns3="http://www.i2b2.org/xsd/cell/crc/pdo/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/plugin/" xmlns:ns6="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/">
<message_header>
<proxy>
<redirect_url>http://i2b2-tmp.kcc.tju.edu:8080/i2b2/rest/QueryToolService/request</redirect_url>
</proxy>
<sending_application>
<application_name>i2b2_QueryTool</application_name>
<application_version>0.2</application_version>
</sending_application>
<sending_facility>
<facility_name>PHS</facility_name>
</sending_facility>
<receiving_application>
<application_name>i2b2_DataRepositoryCell</application_name>
<application_version>0.2</application_version>
</receiving_application>
<receiving_facility>
<facility_name>PHS</facility_name>
</receiving_facility>
<security>
<domain>i2b2dev</domain>
<username>i2b2</username>
<password token_ms_timeout="1800000" is_token="true">SessionKey:Twn2JOF5QL44TXZJaAcD</password>
</security>
<message_type>
<message_code>Q04</message_code>
<event_type>EQQ</event_type>
</message_type>
<message_control_id>
<message_num>uOAeIN8hvmZ4MR9Y1J317</message_num>
<instance_num>0</instance_num>
</message_control_id>
<processing_id>
<processing_id>P</processing_id>
<processing_mode>I</processing_mode>
</processing_id>
<accept_acknowledgement_type>messageId</accept_acknowledgement_type>
<project_id>demo</project_id>
</message_header>
<request_header>
<result_waittime_ms>180000</result_waittime_ms>
</request_header>
<message_body>
<ns4:psmheader>
<user group="demo" login="i2b2">i2b2</user>
<patient_set_limit>0</patient_set_limit>
<estimated_time>0</estimated_time>
<request_type>CRC_QRY_runQueryInstance_fromQueryDefinition</request_type>
</ns4:psmheader>
<ns4:request xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns4:query_definition_requestType">
<query_definition>
<query_name>BLADDER@16:06:12</query_name>
<specificity_scale>0</specificity_scale>
<panel>
<panel_number>1</panel_number>
<invert>0</invert>
<total_item_occurrences>1</total_item_occurrences>
<item>
<hlevel>4</hlevel>
<item_name>BLADDER</item_name>
<item_key>\\TJUH_BIOSPECIMEN\Biospecimen\Frozen Specimens\A19\BLADDER\</item_key>
<tooltip>\Biospecimen\Specimen Type\Frozen\</tooltip>
<class>ENC</class>
<constrain_by_date>
</constrain_by_date>
<item_icon>FA</item_icon>
<item_is_synonym>false</item_is_synonym>
<constrain_by_value>
<value_type>ENUM</value_type>
<value_type>TEXT</value_type>
<value_constraint>("Malignant")</value_constraint>
<value_operator>IN</value_operator>
</constrain_by_value>
</item>
</panel>
</query_definition>
<result_output_list><result_output priority_index="1" name="patient_count_xml" /></result_output_list>
</ns4:request>
</message_body>
****************************************************************************