Query Builder 2.0

Build queries using friendly filters. The system translates your choices into the underlying MongoDB query language.

Switch to Classic Query Builder
Filters
Leave empty to query all active hospitals.
Based on DM.AGE in years.
Maps to DM.SEX.
Matches SC.COUNTRY via SCTESTCD = CTRYPAD.
Uses VS row where VSTEST = "Body Mass Index".
Uses VS rows where VSTEST = "Systolic Blood Pressure" / VSTEST = "Diastolic Blood Pressure".
Default: USUBJID, DM, VS, SC.
If you select none, IMS will request {"{}"} (all fields).
Synthetic data uses a flat schema (e.g. Age, Sex, body-mass index (BMI)). Select fields to return and add simple filters below.
Default: none selected (returns all fields).
Hardcoded list for now.
Results

Choose filters on the left and click "Run Guided Query" to see results here.