HubSpot filters
This article describes filtering capabilities for HubSpot data in LightLead reports.
Available filters
HubSpot filtering: via filterGroups with operators EQ, NEQ, LT, GT, LTE, GTE, IN, NOT_IN, HAS_PROPERTY, NOT_HAS_PROPERTY. Filtering by dealstage, amount, closedate, createdate, hubspot_owner_id, and custom properties is 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 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