JDBC Driver for Pipedrive

Build 24.0.9062

FilterHelpers

Returns all supported filter helpers.

Columns

Name Type Description
AdminAreaLevel1 String AdminAreaLevel1.
AdminAreaLevel2 String AdminAreaLevel2.
Country String Country.
FormattedAddress String FormattedAddress.
Locality String Locality.
PostalCode String PostalCode.
Route String Route.
StreetNumber String StreetNumber.
Sublocality String Sublocality.
Subpremise String Subpremise.
CurrencyNotEqual String CurrencyNotEqual.
CurrencyEqual String CurrencyEqual.
DateNotEqual String DateNotEqual.
DateLessThan String DateLessThan.
DateLessThanOrEqual String DateLessThanOrEqual.
DateEqual String DateEqual.
DateGreaterThan String DateGreaterThan.
DateGreaterThanOrEqual String DateGreaterThanOrEqual.
DateISNOTNULL String DateISNOTNULL.
DateISNULL String DateISNULL.
DateRangeNotEqual String DateRangeNotEqual.
DateRangeLessThan String DateRangeLessThan.
DateRangeLessThanOrEqual String DateRangeLessThanOrEqual.
DateRangeEqual String DateRangeEqual.
DateRangeGreaterThan String DateRangeGreaterThan.
DateRangeGreaterThanOrEqual String DateRangeGreaterThanOrEqual.
DateRangeDoesNotEndAt String DateRangeDoesNotEndAt.
DateRangeEndsAfter String DateRangeEndsAfter.
DateRangeEndsAt String DateRangeEndsAt.
DateRangeEndsBefore String DateRangeEndsBefore.
DateRangeEndsEAfter String DateRangeEndsEAfter.
DateRangeEndsEBefore String DateRangeEndsEBefore.
DateRangeincludes String DateRangeincludes.
DateRangeISNOTNULL String DateRangeISNOTNULL.
DateRangeISNULL String DateRangeISNULL.
DealNotEqual String DealNotEqual.
DealEqual String DealEqual.
DealISNOTNULL String DealISNOTNULL.
DealISNULL String DealISNULL.
DoubleNotEqual String DoubleNotEqual.
DoubleLessThan String DoubleLessThan.
DoubleLessThanOrEqual String DoubleLessThanOrEqual.
DoubleEqual String DoubleEqual.
DoubleGreaterThan String DoubleGreaterThan.
DoubleGreaterThanOrEqual String DoubleGreaterThanOrEqual.
DoubleISNOTNULL String DoubleISNOTNULL.
DoubleISNULL String DoubleISNULL.
EnteredStageNotEqual String EnteredStageNotEqual.
EnteredStageLessThan String EnteredStageLessThan.
EnteredStageLessThanOrEqual String EnteredStageLessThanOrEqual.
EnteredStageEqual String EnteredStageEqual.
EnteredStageGreaterThan String EnteredStageGreaterThan.
EnteredStageGreaterThanOrEqual String EnteredStageGreaterThanOrEqual.
EnumNotEqual String EnumNotEqual.
EnumEqual String EnumEqual.
EnumISNOTNULL String EnumISNOTNULL.
EnumISNULL String EnumISNULL.
IntNotEqual String IntNotEqual.
IntLessThan String IntLessThan.
IntLessThanOrEqual String IntLessThanOrEqual.
IntEqual String IntEqual.
IntGreaterThan String IntGreaterThan.
IntGreaterThanOrEqual String IntGreaterThanOrEqual.
IntISNOTNULL String IntISNOTNULL.
IntISNULL String IntISNULL.
MonetaryNotEqual String MonetaryNotEqual.
MonetaryLessThan String MonetaryLessThan.
MonetaryLessThanOrEqual String MonetaryLessThanOrEqual.
MonetaryEqual String MonetaryEqual.
MonetaryGreaterThan String MonetaryGreaterThan.
MonetaryGreaterThanOrEqual String MonetaryGreaterThanOrEqual.
MonetaryISNOTNULL String MonetaryISNOTNULL.
MonetaryISNULL String MonetaryISNULL.
OrganizationNotEqual String OrganizationNotEqual.
OrganizationEqual String OrganizationEqual.
OrganizationISNOTNULL String OrganizationISNOTNULL.
OrganizationISNULL String OrganizationISNULL.
PersonNotEqual String PersonNotEqual.
PersonEqual String PersonEqual.
PersonISNOTNULL String PersonISNOTNULL.
PersonISNULL String PersonISNULL.
PipelineNotEqual String PipelineNotEqual.
PipelineEqual String PipelineEqual.
ProductNotEqual String ProductNotEqual.
ProductEqual String ProductEqual.
ProductISNOTNULL String ProductISNOTNULL.
ProductISNULL String ProductISNULL.
SetNotEqual String SetNotEqual.
SetEqual String SetEqual.
SetContains String SetContains.
SetISNOTNULL String SetISNOTNULL.
SetISNULL String SetISNULL.
SetNotContains String SetNotContains.
StageNotEqual String StageNotEqual.
StageEqual String StageEqual.
StageHasBeen String StageHasBeen.
StatusNotEqual String StatusNotEqual.
StatusEqual String StatusEqual.
TimeNotEqual String TimeNotEqual.
TimeLessThan String TimeLessThan.
TimeLessThanOrEqual String TimeLessThanOrEqual.
TimeEqual String TimeEqual.
TimeGreaterThan String TimeGreaterThan.
TimeGreaterThanOrEqual String TimeGreaterThanOrEqual.
TimeISNOTNULL String TimeISNOTNULL.
TimeISNULL String TimeISNULL.
TimerangeNotEqual String TimerangeNotEqual.
TimerangeLessThan String TimerangeLessThan.
TimerangeLessThanOrEqual String TimerangeLessThanOrEqual.
TimerangeEqual String TimerangeEqual.
TimerangeGreaterThan String TimerangeGreaterThan.
TimerangeGreaterThanOrEqual String TimerangeGreaterThanOrEqual.
TimerangedoesNotEndAt String TimerangeDoes_not_end_at.
TimerangeEndsAfter String TimerangeEndsAfter.
TimerangeEndsAt String TimerangeEndsAt.
TimerangeEndsBefore String TimerangeEndsBefore.
TimerangeEndsEAfter String TimerangeEndsEAfter.
TimerangeEndsEBefore String TimerangeEndsEBefore.
TimerangeIncludes String TimerangeIncludes.
TimerangeISNOTNULL String TimerangeISNOTNULL.
TimerangeISNULL String TimerangeISNULL.
TitleEqual String TitleEqual.
TitleLIKE'$%' String TitleLIKE'$%'.
TitleLIKE'%$' String TitleLIKE'%$'.
TitleLIKE'%$%' String TitleLIKE'%$%'.
TitleNOTLIKE'$%' String TitleNOTLIKE'$%'.
TitleNOTLIKE'%$' String TitleNOTLIKE'%$'.
TitleNOTLIKE'%$%' String TitleNOTLIKE'%$%'.
UserNotEqual String UserNotEqual.
UserEqual String UserEqual.
UserBelongsToTeam String User.belongs_to_team.
UserISNOTNULL String User.IS_NOT_NULL.
UserISNULL String User.IS_NULL.
VarcharNotEqual String VarcharNotEqual.
VarcharEqual String VarcharEqual.
VarcharISNOTNULL String VarcharISNOTNULL.
VarcharISNULL String VarcharISNULL.
VarcharLIKE'$%' String VarcharLIKE'$%'
VarcharLIKE'%$' String VarcharLIKE'%$'
VarcharLIKE'%$%' String VarcharLIKE'%$%'
VarcharNOTLIKE'$%' String VarcharNOTLIKE'$%'
VarcharNOTLIKE'%$' String VarcharNOTLIKE'%$'
VarcharNOTLIKE'%$%' String VarcharNOTLIKE'%$%'
VisibletoNotEqual String VisibletoNotEqual.
VisibletoEqual String VisibletoEqual.
RottenTime String RottenTime.
LastMonth String LastMonth.
LastQuarter String LastQuarter.
LastWeek String LastWeek.
NextMonth String NextMonth.
NextWeek String NextWeek.
ThisMonth String ThisMonth.
ThisQuarter String ThisQuarter.
ThisWeek String ThisWeek.
OnemonthsAgo String OnemonthsAgo.
OneweekAgo String OneweekAgo.
TwoMonthsAgo String TwoMonthsAgo.
TwoWeeksAgo String TwoWeeksAgo.
ThreeMonthsAgo String ThreeMonthsAgo.
ThreeWeeksAgo String ThreeWeeksAgo.
FourMonthsAgo String FourMonthsAgo.
FiveMonthsAgo String FiveMonthsAgo.
SixMonthsAgo String SixMonthsAgo.
BeforeToday String BeforeToday.
BeforeTomorrow String BeforeTomorrow.
InOneMonth String InOneMonth.
InOneWeek String InOneWeek.
InTwoMonths String InTwoMonths.
InTwoWeeks String InTwoWeeks.
InThreeMonths String InThreeMonths.
InThreeWeeks String InThreeWeeks.
InFourMonths String InFourMonths.
InFiveMonths String InFiveMonths.
InSixMonths String InSixMonths.
LaterOrToday String LaterOrToday.
LaterOrTomorrow String LaterOrTomorrow.
Now String Now.
Today String Today.
Tomorrow String Tomorrow.
Yesterday String Yesterday.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062