Kommo Filters
This article describes the options for filtering Kommo data in LightLead reports.
Available Filters
Filtering Kommo data is supported by deal status, pipeline, creation date, closing date, responsible user, and custom field values. Filters are combined via AND/OR.
Filter Operators
| Operator | Description | Example |
|---|---|---|
| equals | Exact match | Status = "Closed" |
| not_equals | Not equal | Status != "Cancelled" |
| contains | Contains a 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 set |
| is_not_empty | Not empty | Phone is set |
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 Specifics
Text fields: filtering is case-sensitive for exact match, case-insensitive for contains
Numeric fields: support arithmetic comparison operators
Dates: filtering is done in UTC, keep the time zone in mind
Custom fields: available in filters after discovery
Enum (select): filtering is done by the system value, not the display name