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. |