SQLOperator

The available SQL operators that are used to filter query results.

enum SQLOperator {
  BETWEEN
  EQ
  GT
  GTE
  IN
  IS_NOT_NULL
  IS_NULL
  LIKE
  LT
  LTE
  NEQ
  NOT_BETWEEN
  NOT_IN
  NOT_LIKE
}

Values

SQLOperator.BETWEEN

Whether a value is within a range of values (BETWEEN)

SQLOperator.EQ

Equal operator (=)

SQLOperator.GT

Greater than operator (>)

SQLOperator.GTE

Greater than or equal operator (>=)

SQLOperator.IN

Whether a value is within a set of values (IN)

SQLOperator.IS_NOT_NULL

Whether a value is not null (IS NOT NULL)

SQLOperator.IS_NULL

Whether a value is null (IS NULL)

SQLOperator.LIKE

Simple pattern matching (LIKE)

SQLOperator.LT

Less than operator (<)

SQLOperator.LTE

Less than or equal operator (<=)

SQLOperator.NEQ

Not equal operator (!=)

SQLOperator.NOT_BETWEEN

Whether a value is not within a range of values (NOT BETWEEN)

SQLOperator.NOT_IN

Whether a value is not within a set of values (NOT IN)

SQLOperator.NOT_LIKE

Negation of simple pattern matching (NOT LIKE)

Member Of

ContactFormSubmissionsWhereWhereConditions input ● ContactFormSubmissionsWhereWhereConditionsRelation input ● ContactTotalBouncesWhereWhereConditions input ● ContactTotalBouncesWhereWhereConditionsRelation input ● ContactTotalClicksWhereWhereConditions input ● ContactTotalClicksWhereWhereConditionsRelation input ● ContactTotalOpensWhereWhereConditions input ● ContactTotalOpensWhereWhereConditionsRelation input ● ContactTotalOptOutsWhereWhereConditions input ● ContactTotalOptOutsWhereWhereConditionsRelation input ● ContactTotalSendsWhereWhereConditions input ● ContactTotalSendsWhereWhereConditionsRelation input ● ContactVisitsWhereWhereConditions input ● ContactVisitsWhereWhereConditionsRelation input ● ListContactsHasListParticipationChangesWhereHasConditions input ● ListContactsHasListParticipationChangesWhereHasConditionsRelation input ● ListContactsWhereWhereConditions input ● ListContactsWhereWhereConditionsRelation input ● ListListParticipationChangesWhereWhereConditions input ● ListListParticipationChangesWhereWhereConditionsRelation input ● QueryAccountContactsWhereWhereConditions input ● QueryAccountContactsWhereWhereConditionsRelation input ● QueryAccountCustomFieldsWhereWhereConditions input ● QueryAccountCustomFieldsWhereWhereConditionsRelation input ● QueryAccountNotesWhereWhereConditions input ● QueryAccountNotesWhereWhereConditionsRelation input ● QueryAccountsWhereWhereConditions input ● QueryAccountsWhereWhereConditionsRelation input ● QueryActionSendSplitSelectionWhereWhereConditions input ● QueryActionsWhereWhereConditions input ● QueryActionsWhereWhereConditionsRelation input ● QueryActionSyncToDynamicsActivityWhereWhereConditions input ● QueryActionSyncToSalesForceActivityWhereWhereConditions input ● QueryActionSyncToSugarActivityWhereWhereConditions input ● QueryAlertsWhereWhereConditions input ● QueryAlertsWhereWhereConditionsRelation input ● QueryAssetDomainsWhereWhereConditions input ● QueryAssetDomainsWhereWhereConditionsRelation input ● QueryAutomatedActionsWhereWhereConditions input ● QueryAutomatedActionsWhereWhereConditionsRelation input ● QueryAutomationSendScheduleWhereWhereConditions input ● QueryAutomationWhereWhereConditions input ● QueryBrandKitsWhereWhereConditions input ● QueryBrandKitsWhereWhereConditionsRelation input ● QueryCampaignsWhereWhereConditions input ● QueryCampaignsWhereWhereConditionsRelation input ● QueryClassicFormSubmissionsDashboardDefaultViewWhereWhereConditions input ● QueryClassicFormSubmissionsDashboardDefaultViewWhereWhereConditionsRelation input ● QueryClassicFormSubmissionsWhereWhereConditions input ● QueryClassicFormSubmissionsWhereWhereConditionsRelation input ● QueryClassicFormsWhereWhereConditions input ● QueryClassicFormsWhereWhereConditionsRelation input ● QueryContactCustomFieldsWhereWhereConditions input ● QueryContactCustomFieldsWhereWhereConditionsRelation input ● QueryContactNotesWhereWhereConditions input ● QueryContactNotesWhereWhereConditionsRelation input ● QueryContactsWhereWhereConditions input ● QueryContactsWhereWhereConditionsRelation input ● QueryCrmUsersWhereWhereConditions input ● QueryCrmUsersWhereWhereConditionsRelation input ● QueryCustomObjectDefinitionsWhereWhereConditions input ● QueryCustomObjectDefinitionsWhereWhereConditionsRelation input ● QueryCustomObjectRecordsWhereWhereConditions input ● QueryCustomObjectRecordsWhereWhereConditionsRelation input ● QueryCustomObjectRelationshipRecordsWhereWhereConditions input ● QueryCustomObjectRelationshipRecordsWhereWhereConditionsRelation input ● QueryDataEnrichmentAuditsWhereWhereConditions input ● QueryDataEnrichmentAuditsWhereWhereConditionsRelation input ● QueryDownloadableReportsWhereWhereConditions input ● QueryDownloadableReportsWhereWhereConditionsRelation input ● QueryDownloadsWhereWhereConditions input ● QueryDownloadsWhereWhereConditionsRelation input ● QueryDropDownsWhereWhereConditions input ● QueryDropDownsWhereWhereConditionsRelation input ● QueryDynamicsIntegrationErrorsWhereWhereConditions input ● QueryDynamicsIntegrationErrorsWhereWhereConditionsRelation input ● QueryEmailsWhereWhereConditions input ● QueryEmailsWhereWhereConditionsRelation input ● QueryEmailTemplatesWhereWhereConditions input ● QueryEmailTemplatesWhereWhereConditionsRelation input ● QueryEventCampaignWhereWhereConditions input ● QueryFolderWhereWhereConditions input ● QueryFormMapsWhereWhereConditions input ● QueryFormMapsWhereWhereConditionsRelation input ● QueryFormSubmissionsWhereWhereConditions input ● QueryFormSubmissionsWhereWhereConditionsRelation input ● QueryFormsWhereWhereConditions input ● QueryFormsWhereWhereConditionsRelation input ● QueryIntranetBillingInstancesWhereWhereConditions input ● QueryIntranetBillingInstancesWhereWhereConditionsRelation input ● QueryIntranetBillingStatementsWhereWhereConditions input ● QueryIntranetBillingStatementsWhereWhereConditionsRelation input ● QueryLandingPagesWhereWhereConditions input ● QueryLandingPagesWhereWhereConditionsRelation input ● QueryLeadScoreRulesetsWhereWhereConditions input ● QueryLeadScoreRulesetsWhereWhereConditionsRelation input ● QueryLeadScoringThresholdsWhereWhereConditions input ● QueryLeadScoringThresholdsWhereWhereConditionsRelation input ● QueryLeadStageChangeActionsWhereWhereConditions input ● QueryLeadStageChangeActionsWhereWhereConditionsRelation input ● QueryListsWhereWhereConditions input ● QueryListsWhereWhereConditionsRelation input ● QueryMarketingCampaignsWhereWhereConditions input ● QueryMarketingCampaignsWhereWhereConditionsRelation input ● QueryNotificationsWhereWhereConditions input ● QueryNotificationsWhereWhereConditionsRelation input ● QueryOauthAppsWhereWhereConditions input ● QueryOauthAppsWhereWhereConditionsRelation input ● QueryOpportunityStageChangeActionsWhereWhereConditions input ● QueryOpportunityStageChangeActionsWhereWhereConditionsRelation input ● QueryPackagesWhereWhereConditions input ● QueryPackagesWhereWhereConditionsRelation input ● QueryReportRecipientsWhereWhereConditions input ● QueryReportRecipientsWhereWhereConditionsRelation input ● QueryReportsWhereWhereConditions input ● QueryReportsWhereWhereConditionsRelation input ● QuerySalesforceIntegrationErrorsWhereWhereConditions input ● QuerySalesforceIntegrationErrorsWhereWhereConditionsRelation input ● QuerySalesforceOpportunitiesWhereWhereConditions input ● QuerySalesforceOpportunitiesWhereWhereConditionsRelation input ● QuerySegmentsWhereWhereConditions input ● QuerySegmentsWhereWhereConditionsRelation input ● QuerySmsMessagesWhereWhereConditions input ● QuerySmsMessagesWhereWhereConditionsRelation input ● QuerySocialMediaAccountsWhereWhereConditions input ● QuerySocialMediaAccountsWhereWhereConditionsRelation input ● QuerySocialPostsWhereWhereConditions input ● QuerySocialPostsWhereWhereConditionsRelation input ● QuerySubscriptionsWhereWhereConditions input ● QuerySubscriptionsWhereWhereConditionsRelation input ● QuerySugarIntegrationErrorsWhereWhereConditions input ● QuerySugarIntegrationErrorsWhereWhereConditionsRelation input ● QuerySunsetContactWhereWhereConditions input ● QuerySunsetContactWhereWhereConditionsRelation input ● QuerySwoogoEventsWhereWhereConditions input ● QuerySwoogoEventsWhereWhereConditionsRelation input ● QueryTasksWhereWhereConditions input ● QueryTasksWhereWhereConditionsRelation input ● QueryUploadHistoryWhereWhereConditions input ● QueryUploadHistoryWhereWhereConditionsRelation input ● QueryUsersWhereWhereConditions input ● QueryUsersWhereWhereConditionsRelation input ● QueryViewsWhereWhereConditions input ● QueryViewsWhereWhereConditionsRelation input ● QueryVisitsWhereHasContactWhereHasConditions input ● QueryVisitsWhereHasContactWhereHasConditionsRelation input ● QueryVisitsWhereWhereConditions input ● QueryVisitsWhereWhereConditionsRelation input ● QueryWebinarsWhereWhereConditions input ● QueryWebinarsWhereWhereConditionsRelation input ● QueryWorkflowAuditWhereWhereConditions input ● QueryWorkflowCompletionWhereWhereConditions input ● QueryWorkflowNodeQualificationWhereWhereConditions input ● QueryWorkflowQualificationWhereWhereConditions input ● QueryWorkflowsWhereWhereConditions input ● QueryWorkflowsWhereWhereConditionsRelation input ● WhereConditions input ● WhereConditionsRelation input