Query builder
Build a filter over CDEK's data without writing SQL. Every field and operator here is explicitly allow-listed server-side — see the migration plan's Phase 2 notes on why this replaces the legacy app's raw-SQL query tool.
One row per trial × sponsoring-organization × linked-drug combination — legacy's default query-tool view. A trial with multiple sponsors or drugs naturally produces multiple rows; use "Return distinct" thinking when interpreting counts.
Field reference — Trials (merged)
New to the query builder? See the guide for how conditions work.
| Field | Type | Operators |
|---|---|---|
| Trial number | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Trial phase | enum | is, is not, is one of |
| Trial phase group | enum | is, is not, is one of |
| Trial type | string | is, is not, contains, is empty, is not empty |
| Treatment group | enum | is, is not, is one of |
| Completion date | date | is, >, >=, <, <=, is empty, is not empty |
| Enrollment | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Start date | date | is, >, >=, <, <=, is empty, is not empty |
| Org relationship type | enum | is, is not, is one of |
| API ID | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Drug name | string | is, is not, contains, is empty, is not empty |
| Drug type | enum | is, is not, is one of |
| Drug type category | enum | is, is not, is one of |
| Drug approval status | enum | is, is not, is one of |
| Drug max phase | enum | is, is not, is one of |
| Drug FDA approved | boolean | is |
| Drug FDA approval year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Drug US marketed | boolean | is |
| Drug US marketing year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Organization | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Organization name | string | is, is not, contains, is empty, is not empty |
| Org type | enum | is, is not, is one of |
| Parent organization | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Org contributed to NME? | boolean | is |
| Org status | enum | is, is not, is one of |
| Org Trials Status | enum | is, is not, is one of |
| Org founded year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Org entered year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Org last activity year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Org exited year | number | is, is not, >, >=, <, <=, is empty, is not empty |