HighLevel filters
This article describes filtering capabilities for HighLevel data in LightLead reports.
Available filters
HighLevel filtering: by status, pipeline, stage, creation date, update date, assigned user, custom field values. Filters are applied within the specified location_id.
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 list | Status in (New, In progress) |
| not_in | Not in 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 | In range | Date between 01.01 and 31.01 |
| is_empty | Empty value | Manager not specified |
| is_not_empty | Not empty | Phone specified |
Combining filters
Filters can be combined using logical operators:
AND: all conditions must be true simultaneously
OR: at least one condition must be true
Combination example:
(Status = "In progress" AND Amount > 10000) OR (Status = "New" AND Created date > 06/01/2026)Filtering specifics
Text fields: filtering is case-sensitive for exact match, case-insensitive for contains
Number fields: support arithmetic comparison operators
Dates: filtering is in UTC, account for time zone
Custom fields: available in filters after discovery
Enum (select): filtering by the system value, not the display name