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 organization, joined to its trial/marketing summary and lifecycle status.
Field reference — Organizations
New to the query builder? See the guide for how conditions work.
| Field | Type | Operators |
|---|---|---|
| Name | string | is, is not, contains, is empty, is not empty |
| Org type | enum | is, is not, is one of |
| Founded country | string | is, is not, contains, is empty, is not empty |
| Founded date | date | is, >, >=, <, <=, is empty, is not empty |
| Trial count | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Has orphan-drug designation | boolean | is |
| Org status | enum | is, is not, is one of |
| Org Trials Status | enum | is, is not, is one of |
| Contributed to NME? | boolean | is |
| Parent organization | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Founded year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Entered year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| First clinical trial year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| First marketed drug year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| First NDA year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Last activity year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Exited year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Acquired year | number | is, is not, >, >=, <, <=, is empty, is not empty |
| Defunct year | number | is, is not, >, >=, <, <=, is empty, is not empty |