Page History
...
When the User runs a query with User created Data Request option selected, a row is logged in the QT_Query_Result_Instance for the result_type_oid generated in the QT_Result_type
| Column Name | Value (Example) |
|---|---|
| Result_Type_ id | 256 |
| Result_instance_id | 541 |
QT_BREAKDOWN_PATH - Data File Creation
The Value column is updated with result_instance_id from the Q_Result_Instance in the EXEC statement and the stored procedure to generate the Data flle is executed
Example:
| NAME | VALUE |
|---|---|
RPDO_<Table_instance_id> Example: RPDO_144 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=<Table_instance_id> @RESULT_INSTANCE_ID=541 @MIN_ROW=0 @MAX_ROW=10000 |
QT_XML_RESULT
When the create Data file stored procedure is executed, row is logged in the QT_XML_Result for the result_instance_id with the details of Data table Definition in the Value column
| Column Name | Value (example) |
|---|---|
| Result_Instance_Id | 541 |
| 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="RPDO_144"> <data column="SUBMITTED" type="string">20250513_172906</data> <data column="EMAIL" type="string">act@gmail.com</data> </ns10:result> </body> </ns10:i2b2_result_envelope> |
Data file format/location and Email parameters set-up: HIVE_CELL_PARAMS
...
