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.

Data set

One row per API/compound, joined to its approval, regulatory-designation, and trial-phase summary.

Field reference — Drugs

New to the query builder? See the guide for how conditions work.

Field	Type	Operators
API ID	number	is, is not, >, >=, <, <=, is empty, is not empty
Primary name	string	is, is not, contains, is empty, is not empty
Trade 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
Approval status	enum	is, is not, is one of
Max trial phase	enum	is, is not, is one of
Trial count	number	is, is not, >, >=, <, <=, is empty, is not empty
Approval date	date	is, >, >=, <, <=, is empty, is not empty
COVID-19 related	boolean	is
FDA approved	boolean	is
FDA approval year	number	is, is not, >, >=, <, <=, is empty, is not empty
US marketed	boolean	is
US marketing year	number	is, is not, >, >=, <, <=, is empty, is not empty
Priority Review	boolean	is
Orphan designated	boolean	is
Orphan designation year	number	is, is not, >, >=, <, <=, is empty, is not empty
Accelerated Approval	boolean	is
Fast Track	boolean	is
Breakthrough Therapy	boolean	is