Bitrix24 Filters
This article describes the data filtering capabilities for Bitrix24 in LightLead reports.
Available Filters
Filtering Bitrix24 data: by deal status, stage, pipeline, creation date, closing date, and owner. Filters on UTM tags (utm_source, utm_medium, etc.) and custom field values are also supported.
Filter Operators
| Operator | Description | Example |
|---|---|---|
| equals | Exact match | Status = "Closed" |
| not_equals | Not equal | Status != "Cancelled" |
| contains | Contains substring | Name contains "Project" |
| not_contains | Does not contain | Name does not contain "Test" |
| in | In a list | Status in (New, In Progress) |
| not_in | Not in a list | Status not in (Cancelled, Duplicate) |
| gt / gte | Greater than / greater than or equal | Amount > 10000 |
| lt / lte | Less than / less than or equal | Amount < 5000 |
| between | Within a range | Date between 01.01 and 31.01 |
| is_empty | Empty value | Manager is not specified |
| is_not_empty | Not empty | Phone is specified |
Combining Filters
Filters can be combined using logical operators:
AND: all conditions must be true at the same time
OR: at least one condition must be true
Example of combining:
(Status = "In Progress" AND Amount > 10000) OR (Status = "New" AND Creation Date > 01.06.2026)Filtering Notes
Text fields: filtering is case-sensitive for exact match, case-insensitive for contains
Numeric fields: support arithmetic comparison operators
Dates: filtering is by UTC, keep the time zone in mind
Custom fields: available in filters after discovery
Enum (select): filtering is by the system value, not the display name