FilterHelpers
Returns all supported filter helpers.
Columns
Name | Type | References | 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. |