Pipedrive Filters
This article describes the filtering capabilities for Pipedrive data in LightLead reports.
Available filters
Filtering Pipedrive data: by status, funnel, stage, creation date (add_time), update date (update_time), win date (won_time), loss date (lost_time), deal value (value), currency, owner.
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 met simultaneously
OR: at least one condition must be met
Example of combining:
(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
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 displayed name