Run SQL Breakdown
http://127.0.0.1:9090/i2b2/services/QueryToolService/breakdownrequest
<message_body>
<result_output_list><result_output priority_index="1" name="ADMIN_TOP10USERS_XML"/></result_output_list>
</ns4:request>
Response
<message_body>
<ns4:response xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns4:crc_xml_result_responseType">
DONE
<crc_xml_result>
<xml_value><?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns10:i2b2_result_envelope xmlns:ns6="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/pm/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/crc/psm/analysisdefinition/1.1/" xmlns:ns9="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns10="http://www.i2b2.org/xsd/hive/msg/result/1.1/" 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/">
<body>
<ns10:result name="ADMIN_TOP10USERS_XML">
<data column="demo" type="int">2642</data>
<data column="demoManager" type="int">350</data>
<data column="demoid" type="int">208</data>
<data column="demotest" type="int">201</data>
<data column="demoLDS" type="int">174</data>
<data column="rm302" type="int">170</data>
<data column="demoOb" type="int">128</data>
<data column="demoDeid" type="int">105</data>
<data column="demoProt" type="int">77</data>
<data column="i2b2" type="int">73</data>
</ns10:result>
</body>
</ns10:i2b2_result_envelope></xml_value>
</crc_xml_result>
</ns4:response>
</message_body>
Run SQL Breakdown
http://127.0.0.1:9090/i2b2/services/QueryToolService/breakdownrequest
<message_body>
<result_output_list><result_output priority_index="1" name="ADMIN_TOP10USERS_XML"/></result_output_list>
</ns4:request>
Response
<message_body>
<ns4:response xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns4:crc_xml_result_responseType">
DONE
<crc_xml_result>
<xml_value><?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns10:i2b2_result_envelope xmlns:ns6="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/pm/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/crc/psm/analysisdefinition/1.1/" xmlns:ns9="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns10="http://www.i2b2.org/xsd/hive/msg/result/1.1/" 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/">
<body>
<ns10:result name="ADMIN_TOP10USERS_XML">
<data column="demo" type="int">2642</data>
<data column="demoManager" type="int">350</data>
<data column="demoid" type="int">208</data>
<data column="demotest" type="int">201</data>
<data column="demoLDS" type="int">174</data>
<data column="rm302" type="int">170</data>
<data column="demoOb" type="int">128</data>
<data column="demoDeid" type="int">105</data>
<data column="demoProt" type="int">77</data>
<data column="i2b2" type="int">73</data>
</ns10:result>
</body>
</ns10:i2b2_result_envelope></xml_value>
</crc_xml_result>
</ns4:response>
</message_body>