KeyCRM Filters
This article describes the options for filtering KeyCRM data in LightLead reports.
Available Filters
KeyCRM order filtering: by status, creation date, update date, payment status, delivery type, manager, custom field values, and buyer fields (phone, email).
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