Developers Getting Started With i2b2
Space shortcuts
Space Tools
Developers Getting Started With i2b2 getstarted

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

We recommend data requests be limited to DATA_LDS users (irrespective of Admin path role - admin, user, manager) and data exports be limited to MANAGER users (irrespective of data path role - data_lds, data_agg,data_obf, data_deid). The user role determines if exports/requests are visible and runnable. 

 QT_QUERY_RESULT_TYPEuser roleUser-created data requestdata Request ManagerVisibility/Actions

 DATA_LDS

DATA_LDS

Success

Success

Only  user-created requests

MANAGER with

DATA_LDS

DATA_LDS

Success

Success

All user-created requests

MANAGER

without DATA_LDS

MANAGER

?

??

Admin

Admin

?

??



Data Request

...

definition details: QT_BREAKDOWN_PATH

QT_BREAKDOWN_PATH defines  the table definition value and the result_instance_id. to be associated with the ptset. query.

...

NAMEVALUE
RPDO_78

EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=78 @RESULT_INSTANCE_ID={{{RESULT_INSTANCE_ID}}} @MIN_ROW=0 @MAX_ROW=10000

Example Requests

NAMEVALUERPDO_78


Export file format/location and Email parameters set-up: HIVE_CELL_PARAMS

...

Developers Getting Started With i2b2 getstarted