How are the QT_BREAKDOWN_PATH's inserted?

29 views
Skip to first unread message

cmc

unread,
Jul 1, 2025, 12:32:50 PMJul 1
to i2b2 Install Help
On a fresh installation of i2b2 demodata, I have 20 items in QT_BREAKDOWN_PATH.
 
12 of them do NOT have a CREATE_DATE, and the values are XML text.
These 12 have names ending in _CSV and _REQUEST.
PATIENT_DEMOGRAPHIC_CSV
PATIENT_DEMOGRAPHIC_REQUEST
...
I can see the insert statements for these 12 in the setup scripts.

But there are 8 additional rows that DO have a CREATE_DATE filled in and the values are either concept paths or select queries:
PATIENT_GENDER_COUNT_XML
PATIENT_RACE_COUNT_XML
PATIENT_VITALSTATUS_COUNT_XML
PATIENT_AGE_COUNT_XML
PATIENT_LOS_XML
PATIENT_TOP20MEDS_XML
PATIENT_TOP20DIAG_XML
PATIENT_INOUT_XML

I cannot find where/how these were inserted - I don't see any statements in the install scripts, and so far cannot find anything in the code or stored procedures either.
How/where are these being inserted?
I'm asking because I want to add to/edit them, but it appears they may be dynamically generated?

Jeff Klann

unread,
Jul 10, 2025, 11:43:57 AMJul 10
to i2b2 Install Help
The project and database in your db.properties file determines which version of QT_BREAKDOWN_PATH you get. For example, the demo project on MSSQL gets these files:


Note that some of the inserts are in a script inside the ZIP file.

Hope that helps!

Thanks,
Jeff

Reply all
Reply to author
Forward
0 new messages