ADO.NET Provider for Pipedrive

Build 26.0.9655

FilterHelpers

Returns all supported filter helper values used when constructing Pipedrive filters, including address field components, operator tokens for each data type, and relative date expressions.

Columns

Name Type References Description
AdminAreaLevel1 String The first-level administrative area component of an address, such as a state or province.
AdminAreaLevel2 String The second-level administrative area component of an address, such as a county or district.
Country String The country component of an address field.
FormattedAddress String The full formatted address string combining all address components.
Locality String The city or locality component of an address field.
PostalCode String The postal or ZIP code component of an address field.
Route String The street name or route component of an address field.
StreetNumber String The street number component of an address field.
Sublocality String The sub-locality component of an address field, such as a neighborhood or borough.
Subpremise String The sub-premise component of an address field, such as an apartment or suite number.
CurrencyNotEqual String The not-equal operator token for use with currency field filters.
CurrencyEqual String The equality operator token for use with currency field filters.
DateNotEqual String The not-equal operator token for use with date field filters.
DateLessThan String The less-than operator token for use with date field filters.
DateLessThanOrEqual String The less-than-or-equal operator token for use with date field filters.
DateEqual String The equality operator token for use with date field filters.
DateGreaterThan String The greater-than operator token for use with date field filters.
DateGreaterThanOrEqual String The greater-than-or-equal operator token for use with date field filters.
DateISNOTNULL String The IS NOT NULL operator token for use with date field filters.
DateISNULL String The IS NULL operator token for use with date field filters.
DateRangeNotEqual String The not-equal operator token for use with date range field filters.
DateRangeLessThan String The less-than operator token for use with date range field filters.
DateRangeLessThanOrEqual String The less-than-or-equal operator token for use with date range field filters.
DateRangeEqual String The equality operator token for use with date range field filters.
DateRangeGreaterThan String The greater-than operator token for use with date range field filters.
DateRangeGreaterThanOrEqual String The greater-than-or-equal operator token for use with date range field filters.
DateRangeDoesNotEndAt String The does-not-end-at operator token for use with date range field filters.
DateRangeEndsAfter String The ends-after operator token for use with date range field filters.
DateRangeEndsAt String The ends-at operator token for use with date range field filters.
DateRangeEndsBefore String The ends-before operator token for use with date range field filters.
DateRangeEndsEAfter String The ends-on-or-after operator token for use with date range field filters.
DateRangeEndsEBefore String The ends-on-or-before operator token for use with date range field filters.
DateRangeincludes String The includes operator token for use with date range field filters.
DateRangeISNOTNULL String The IS NOT NULL operator token for use with date range field filters.
DateRangeISNULL String The IS NULL operator token for use with date range field filters.
DealNotEqual String The not-equal operator token for use with deal field filters.
DealEqual String The equality operator token for use with deal field filters.
DealISNOTNULL String The IS NOT NULL operator token for use with deal field filters.
DealISNULL String The IS NULL operator token for use with deal field filters.
DoubleNotEqual String The not-equal operator token for use with decimal number field filters.
DoubleLessThan String The less-than operator token for use with decimal number field filters.
DoubleLessThanOrEqual String The less-than-or-equal operator token for use with decimal number field filters.
DoubleEqual String The equality operator token for use with decimal number field filters.
DoubleGreaterThan String The greater-than operator token for use with decimal number field filters.
DoubleGreaterThanOrEqual String The greater-than-or-equal operator token for use with decimal number field filters.
DoubleISNOTNULL String The IS NOT NULL operator token for use with decimal number field filters.
DoubleISNULL String The IS NULL operator token for use with decimal number field filters.
EnteredStageNotEqual String The not-equal operator token for use with entered-stage field filters.
EnteredStageLessThan String The less-than operator token for use with entered-stage field filters.
EnteredStageLessThanOrEqual String The less-than-or-equal operator token for use with entered-stage field filters.
EnteredStageEqual String The equality operator token for use with entered-stage field filters.
EnteredStageGreaterThan String The greater-than operator token for use with entered-stage field filters.
EnteredStageGreaterThanOrEqual String The greater-than-or-equal operator token for use with entered-stage field filters.
EnumNotEqual String The not-equal operator token for use with enumeration field filters.
EnumEqual String The equality operator token for use with enumeration field filters.
EnumISNOTNULL String The IS NOT NULL operator token for use with enumeration field filters.
EnumISNULL String The IS NULL operator token for use with enumeration field filters.
IntNotEqual String The not-equal operator token for use with integer field filters.
IntLessThan String The less-than operator token for use with integer field filters.
IntLessThanOrEqual String The less-than-or-equal operator token for use with integer field filters.
IntEqual String The equality operator token for use with integer field filters.
IntGreaterThan String The greater-than operator token for use with integer field filters.
IntGreaterThanOrEqual String The greater-than-or-equal operator token for use with integer field filters.
IntISNOTNULL String The IS NOT NULL operator token for use with integer field filters.
IntISNULL String The IS NULL operator token for use with integer field filters.
MonetaryNotEqual String The not-equal operator token for use with monetary field filters.
MonetaryLessThan String The less-than operator token for use with monetary field filters.
MonetaryLessThanOrEqual String The less-than-or-equal operator token for use with monetary field filters.
MonetaryEqual String The equality operator token for use with monetary field filters.
MonetaryGreaterThan String The greater-than operator token for use with monetary field filters.
MonetaryGreaterThanOrEqual String The greater-than-or-equal operator token for use with monetary field filters.
MonetaryISNOTNULL String The IS NOT NULL operator token for use with monetary field filters.
MonetaryISNULL String The IS NULL operator token for use with monetary field filters.
OrganizationNotEqual String The not-equal operator token for use with organization field filters.
OrganizationEqual String The equality operator token for use with organization field filters.
OrganizationISNOTNULL String The IS NOT NULL operator token for use with organization field filters.
OrganizationISNULL String The IS NULL operator token for use with organization field filters.
PersonNotEqual String The not-equal operator token for use with person field filters.
PersonEqual String The equality operator token for use with person field filters.
PersonISNOTNULL String The IS NOT NULL operator token for use with person field filters.
PersonISNULL String The IS NULL operator token for use with person field filters.
PipelineNotEqual String The not-equal operator token for use with pipeline field filters.
PipelineEqual String The equality operator token for use with pipeline field filters.
ProductNotEqual String The not-equal operator token for use with product field filters.
ProductEqual String The equality operator token for use with product field filters.
ProductISNOTNULL String The IS NOT NULL operator token for use with product field filters.
ProductISNULL String The IS NULL operator token for use with product field filters.
SetNotEqual String The not-equal operator token for use with set field filters.
SetEqual String The equality operator token for use with set field filters.
SetContains String The contains operator token for use with set field filters.
SetISNOTNULL String The IS NOT NULL operator token for use with set field filters.
SetISNULL String The IS NULL operator token for use with set field filters.
SetNotContains String The not-contains operator token for use with set field filters.
StageNotEqual String The not-equal operator token for use with stage field filters.
StageEqual String The equality operator token for use with stage field filters.
StageHasBeen String The has-been operator token for use with stage field filters, matching records that were ever in the specified stage.
StatusNotEqual String The not-equal operator token for use with status field filters.
StatusEqual String The equality operator token for use with status field filters.
TimeNotEqual String The not-equal operator token for use with time field filters.
TimeLessThan String The less-than operator token for use with time field filters.
TimeLessThanOrEqual String The less-than-or-equal operator token for use with time field filters.
TimeEqual String The equality operator token for use with time field filters.
TimeGreaterThan String The greater-than operator token for use with time field filters.
TimeGreaterThanOrEqual String The greater-than-or-equal operator token for use with time field filters.
TimeISNOTNULL String The IS NOT NULL operator token for use with time field filters.
TimeISNULL String The IS NULL operator token for use with time field filters.
TimerangeNotEqual String The not-equal operator token for use with time range field filters.
TimerangeLessThan String The less-than operator token for use with time range field filters.
TimerangeLessThanOrEqual String The less-than-or-equal operator token for use with time range field filters.
TimerangeEqual String The equality operator token for use with time range field filters.
TimerangeGreaterThan String The greater-than operator token for use with time range field filters.
TimerangeGreaterThanOrEqual String The greater-than-or-equal operator token for use with time range field filters.
TimerangedoesNotEndAt String The does-not-end-at operator token for use with time range field filters.
TimerangeEndsAfter String The ends-after operator token for use with time range field filters.
TimerangeEndsAt String The ends-at operator token for use with time range field filters.
TimerangeEndsBefore String The ends-before operator token for use with time range field filters.
TimerangeEndsEAfter String The ends-on-or-after operator token for use with time range field filters.
TimerangeEndsEBefore String The ends-on-or-before operator token for use with time range field filters.
TimerangeIncludes String The includes operator token for use with time range field filters.
TimerangeISNOTNULL String The IS NOT NULL operator token for use with time range field filters.
TimerangeISNULL String The IS NULL operator token for use with time range field filters.
TitleEqual String The equality operator token for use with title field filters.
TitleLIKE'$%' String The starts-with LIKE pattern operator token for use with title field filters.
TitleLIKE'%$' String The ends-with LIKE pattern operator token for use with title field filters.
TitleLIKE'%$%' String The contains LIKE pattern operator token for use with title field filters.
TitleNOTLIKE'$%' String The does-not-start-with NOT LIKE pattern operator token for use with title field filters.
TitleNOTLIKE'%$' String The does-not-end-with NOT LIKE pattern operator token for use with title field filters.
TitleNOTLIKE'%$%' String The does-not-contain NOT LIKE pattern operator token for use with title field filters.
UserNotEqual String The not-equal operator token for use with user field filters.
UserEqual String The equality operator token for use with user field filters.
UserBelongsToTeam String The belongs-to-team operator token for use with user field filters, matching users who are members of a specified team.
UserISNOTNULL String The IS NOT NULL operator token for use with user field filters.
UserISNULL String The IS NULL operator token for use with user field filters.
VarcharNotEqual String The not-equal operator token for use with text field filters.
VarcharEqual String The equality operator token for use with text field filters.
VarcharISNOTNULL String The IS NOT NULL operator token for use with text field filters.
VarcharISNULL String The IS NULL operator token for use with text field filters.
VarcharLIKE'$%' String The starts-with LIKE pattern operator token for use with text field filters.
VarcharLIKE'%$' String The ends-with LIKE pattern operator token for use with text field filters.
VarcharLIKE'%$%' String The contains LIKE pattern operator token for use with text field filters.
VarcharNOTLIKE'$%' String The does-not-start-with NOT LIKE pattern operator token for use with text field filters.
VarcharNOTLIKE'%$' String The does-not-end-with NOT LIKE pattern operator token for use with text field filters.
VarcharNOTLIKE'%$%' String The does-not-contain NOT LIKE pattern operator token for use with text field filters.
VisibletoNotEqual String The not-equal operator token for use with visibility field filters.
VisibletoEqual String The equality operator token for use with visibility field filters.
RottenTime String The relative date token representing the time at which a deal becomes rotten, for use in deal-specific date filters.
LastMonth String The relative date interval token representing the previous calendar month.
LastQuarter String The relative date interval token representing the previous calendar quarter.
LastWeek String The relative date interval token representing the previous calendar week.
NextMonth String The relative date interval token representing the next calendar month.
NextWeek String The relative date interval token representing the next calendar week.
ThisMonth String The relative date interval token representing the current calendar month.
ThisQuarter String The relative date interval token representing the current calendar quarter.
ThisWeek String The relative date interval token representing the current calendar week.
OnemonthsAgo String The relative date token representing a point one month before today.
OneweekAgo String The relative date token representing a point one week before today.
TwoMonthsAgo String The relative date token representing a point two months before today.
TwoWeeksAgo String The relative date token representing a point two weeks before today.
ThreeMonthsAgo String The relative date token representing a point three months before today.
ThreeWeeksAgo String The relative date token representing a point three weeks before today.
FourMonthsAgo String The relative date token representing a point four months before today.
FiveMonthsAgo String The relative date token representing a point five months before today.
SixMonthsAgo String The relative date token representing a point six months before today.
BeforeToday String The relative date token representing any date before today.
BeforeTomorrow String The relative date token representing any date before tomorrow, effectively including today.
InOneMonth String The relative date token representing a point one month from today.
InOneWeek String The relative date token representing a point one week from today.
InTwoMonths String The relative date token representing a point two months from today.
InTwoWeeks String The relative date token representing a point two weeks from today.
InThreeMonths String The relative date token representing a point three months from today.
InThreeWeeks String The relative date token representing a point three weeks from today.
InFourMonths String The relative date token representing a point four months from today.
InFiveMonths String The relative date token representing a point five months from today.
InSixMonths String The relative date token representing a point six months from today.
LaterOrToday String The relative date token representing today or any date after today.
LaterOrTomorrow String The relative date token representing tomorrow or any date after tomorrow.
Now String The relative date token representing the current date and time.
Today String The relative date token representing today's date.
Tomorrow String The relative date token representing tomorrow's date.
Yesterday String The relative date token representing yesterday's date.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655