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 ● ContactFormSubmissionsWhereWhereConditionsHasCondition input ● ContactFormSubmissionsWhereWhereConditionsRelation input ● ContactTotalBouncesWhereWhereConditions input ● ContactTotalBouncesWhereWhereConditionsHasCondition input ● ContactTotalBouncesWhereWhereConditionsRelation input ● ContactTotalClicksWhereWhereConditions input ● ContactTotalClicksWhereWhereConditionsHasCondition input ● ContactTotalClicksWhereWhereConditionsRelation input ● ContactTotalOpensWhereWhereConditions input ● ContactTotalOpensWhereWhereConditionsHasCondition input ● ContactTotalOpensWhereWhereConditionsRelation input ● ContactTotalOptOutsWhereWhereConditions input ● ContactTotalOptOutsWhereWhereConditionsHasCondition input ● ContactTotalOptOutsWhereWhereConditionsRelation input ● ContactTotalSendsWhereWhereConditions input ● ContactTotalSendsWhereWhereConditionsHasCondition input ● ContactTotalSendsWhereWhereConditionsRelation input ● ContactVisitsWhereWhereConditions input ● ContactVisitsWhereWhereConditionsHasCondition input ● ContactVisitsWhereWhereConditionsRelation input ● ListContactsHasListParticipationChangesWhereHasConditions input ● ListContactsHasListParticipationChangesWhereHasConditionsHasCondition input ● ListContactsHasListParticipationChangesWhereHasConditionsRelation input ● ListContactsWhereWhereConditions input ● ListContactsWhereWhereConditionsHasCondition input ● ListContactsWhereWhereConditionsRelation input ● ListListParticipationChangesWhereWhereConditions input ● ListListParticipationChangesWhereWhereConditionsHasCondition input ● ListListParticipationChangesWhereWhereConditionsRelation input ● MarketingCampaignMembersWhereWhereConditions input ● MarketingCampaignMembersWhereWhereConditionsHasCondition input ● MarketingCampaignMembersWhereWhereConditionsRelation input ● QueryAccountContactsWhereWhereConditions input ● QueryAccountContactsWhereWhereConditionsHasCondition input ● QueryAccountContactsWhereWhereConditionsRelation input ● QueryAccountCustomFieldsWhereWhereConditions input ● QueryAccountCustomFieldsWhereWhereConditionsHasCondition input ● QueryAccountCustomFieldsWhereWhereConditionsRelation input ● QueryAccountNotesWhereWhereConditions input ● QueryAccountNotesWhereWhereConditionsHasCondition input ● QueryAccountNotesWhereWhereConditionsRelation input ● QueryAccountsWhereWhereConditions input ● QueryAccountsWhereWhereConditionsHasCondition input ● QueryAccountsWhereWhereConditionsRelation input ● QueryActionSetsWhereWhereConditions input ● QueryActionSetsWhereWhereConditionsHasCondition input ● QueryActionSetsWhereWhereConditionsRelation input ● QueryActionsWhereWhereConditions input ● QueryActionsWhereWhereConditionsRelation input ● QueryActionSyncToDynamicsActivityWhereWhereConditions input ● QueryActionSyncToSalesForceActivityWhereWhereConditions input ● QueryActionSyncToSugarActivityWhereWhereConditions input ● QueryAlertsWhereWhereConditions input ● QueryAlertsWhereWhereConditionsHasCondition input ● QueryAlertsWhereWhereConditionsRelation input ● QueryAssetDomainsWhereWhereConditions input ● QueryAssetDomainsWhereWhereConditionsHasCondition input ● QueryAssetDomainsWhereWhereConditionsRelation input ● QueryAutomatedActionsWhereWhereConditions input ● QueryAutomatedActionsWhereWhereConditionsHasCondition input ● QueryAutomatedActionsWhereWhereConditionsRelation input ● QueryAutomationSendScheduleWhereWhereConditions input ● QueryAutomationWhereWhereConditions input ● QueryBrandKitsWhereWhereConditions input ● QueryBrandKitsWhereWhereConditionsHasCondition input ● QueryBrandKitsWhereWhereConditionsRelation input ● QueryCampaignsWhereWhereConditions input ● QueryCampaignsWhereWhereConditionsRelation input ● QueryClassicFormSubmissionsDashboardDefaultViewWhereWhereConditions input ● QueryClassicFormSubmissionsDashboardDefaultViewWhereWhereConditionsHasCondition input ● QueryClassicFormSubmissionsDashboardDefaultViewWhereWhereConditionsRelation input ● QueryClassicFormSubmissionsWhereWhereConditions input ● QueryClassicFormSubmissionsWhereWhereConditionsHasCondition input ● QueryClassicFormSubmissionsWhereWhereConditionsRelation input ● QueryClassicFormsWhereWhereConditions input ● QueryClassicFormsWhereWhereConditionsHasCondition input ● QueryClassicFormsWhereWhereConditionsRelation input ● QueryClassicLandingPagesWhereWhereConditions input ● QueryClassicLandingPagesWhereWhereConditionsRelation input ● QueryCombinedLandingPagesWhereWhereConditions input ● QueryCombinedLandingPagesWhereWhereConditionsHasCondition input ● QueryCombinedLandingPagesWhereWhereConditionsRelation input ● QueryContactCustomFieldsWhereWhereConditions input ● QueryContactCustomFieldsWhereWhereConditionsRelation input ● QueryContactNotesWhereWhereConditions input ● QueryContactNotesWhereWhereConditionsHasCondition input ● QueryContactNotesWhereWhereConditionsRelation input ● QueryContactsWhereWhereConditions input ● QueryContactsWhereWhereConditionsRelation input ● QueryCrmUsersWhereWhereConditions input ● QueryCrmUsersWhereWhereConditionsHasCondition input ● QueryCrmUsersWhereWhereConditionsRelation input ● QueryCustomObjectDefinitionsWhereWhereConditions input ● QueryCustomObjectDefinitionsWhereWhereConditionsHasCondition input ● QueryCustomObjectDefinitionsWhereWhereConditionsRelation input ● QueryCustomObjectRecordsWhereWhereConditions input ● QueryCustomObjectRecordsWhereWhereConditionsHasCondition input ● QueryCustomObjectRecordsWhereWhereConditionsRelation input ● QueryCustomObjectRelationshipRecordsWhereWhereConditions input ● QueryCustomObjectRelationshipRecordsWhereWhereConditionsHasCondition input ● QueryCustomObjectRelationshipRecordsWhereWhereConditionsRelation input ● QueryCustomObjectRelationshipsWhereWhereConditions input ● QueryCustomObjectRelationshipsWhereWhereConditionsHasCondition input ● QueryCustomObjectRelationshipsWhereWhereConditionsRelation input ● QueryDataEnrichmentAuditsWhereWhereConditions input ● QueryDataEnrichmentAuditsWhereWhereConditionsHasCondition input ● QueryDataEnrichmentAuditsWhereWhereConditionsRelation input ● QueryDownloadableReportsWhereWhereConditions input ● QueryDownloadableReportsWhereWhereConditionsRelation input ● QueryDownloadsWhereWhereConditions input ● QueryDownloadsWhereWhereConditionsHasCondition input ● QueryDownloadsWhereWhereConditionsRelation input ● QueryDropDownsWhereWhereConditions input ● QueryDropDownsWhereWhereConditionsHasCondition input ● QueryDropDownsWhereWhereConditionsRelation input ● QueryDynamicsIntegrationErrorsWhereWhereConditions input ● QueryDynamicsIntegrationErrorsWhereWhereConditionsHasCondition input ● QueryDynamicsIntegrationErrorsWhereWhereConditionsRelation input ● QueryEmailsWhereWhereConditions input ● QueryEmailsWhereWhereConditionsRelation input ● QueryEmailTemplatesWhereWhereConditions input ● QueryEmailTemplatesWhereWhereConditionsHasCondition input ● QueryEmailTemplatesWhereWhereConditionsRelation input ● QueryEventAttendeesWhereWhereConditions input ● QueryEventAttendeesWhereWhereConditionsHasCondition input ● QueryEventAttendeesWhereWhereConditionsRelation input ● QueryEventCampaignWhereWhereConditions input ● QueryEventRegistrantsWhereWhereConditions input ● QueryEventRegistrantsWhereWhereConditionsHasCondition input ● QueryEventRegistrantsWhereWhereConditionsRelation input ● QueryEventsWhereWhereConditions input ● QueryEventsWhereWhereConditionsHasCondition input ● QueryEventsWhereWhereConditionsRelation input ● QueryExecutedActionsWhereWhereConditions input ● QueryExecutedActionsWhereWhereConditionsRelation input ● QueryExportsWhereWhereConditions input ● QueryExportsWhereWhereConditionsHasCondition input ● QueryExportsWhereWhereConditionsRelation input ● QueryFolderWhereWhereConditions input ● QueryFormMapsWhereWhereConditions input ● QueryFormMapsWhereWhereConditionsHasCondition input ● QueryFormMapsWhereWhereConditionsRelation input ● QueryFormSubmissionsWhereWhereConditions input ● QueryFormSubmissionsWhereWhereConditionsHasCondition input ● QueryFormSubmissionsWhereWhereConditionsRelation input ● QueryFormsWhereWhereConditions input ● QueryFormsWhereWhereConditionsHasCondition input ● QueryFormsWhereWhereConditionsRelation input ● QueryIntranetBillingInstancesWhereWhereConditions input ● QueryIntranetBillingInstancesWhereWhereConditionsHasCondition input ● QueryIntranetBillingInstancesWhereWhereConditionsRelation input ● QueryIntranetBillingStatementsWhereWhereConditions input ● QueryIntranetBillingStatementsWhereWhereConditionsHasCondition input ● QueryIntranetBillingStatementsWhereWhereConditionsRelation input ● QueryLandingPageHostingDomainsWhereWhereConditions input ● QueryLandingPageHostingDomainsWhereWhereConditionsHasCondition input ● QueryLandingPageHostingDomainsWhereWhereConditionsRelation input ● QueryLandingPagesWhereWhereConditions input ● QueryLandingPagesWhereWhereConditionsHasCondition input ● QueryLandingPagesWhereWhereConditionsRelation input ● QueryLayoutLibraryItemsWhereWhereConditions input ● QueryLayoutLibraryItemsWhereWhereConditionsHasCondition input ● QueryLayoutLibraryItemsWhereWhereConditionsRelation input ● QueryLeadScoreRulesetsWhereWhereConditions input ● QueryLeadScoreRulesetsWhereWhereConditionsHasCondition input ● QueryLeadScoreRulesetsWhereWhereConditionsRelation input ● QueryLeadScoringThresholdsWhereWhereConditions input ● QueryLeadScoringThresholdsWhereWhereConditionsHasCondition input ● QueryLeadScoringThresholdsWhereWhereConditionsRelation input ● QueryLeadStageChangeActionsWhereWhereConditions input ● QueryLeadStageChangeActionsWhereWhereConditionsHasCondition input ● QueryLeadStageChangeActionsWhereWhereConditionsRelation input ● QueryListsWhereWhereConditions input ● QueryListsWhereWhereConditionsHasCondition input ● QueryListsWhereWhereConditionsRelation input ● QueryMarketingCampaignMemberCustomFieldsWhereWhereConditions input ● QueryMarketingCampaignMemberCustomFieldsWhereWhereConditionsHasCondition input ● QueryMarketingCampaignMemberCustomFieldsWhereWhereConditionsRelation input ● QueryMarketingCampaignMembersWhereWhereConditions input ● QueryMarketingCampaignMembersWhereWhereConditionsHasCondition input ● QueryMarketingCampaignMembersWhereWhereConditionsRelation input ● QueryMarketingCampaignsWhereWhereConditions input ● QueryMarketingCampaignsWhereWhereConditionsHasCondition input ● QueryMarketingCampaignsWhereWhereConditionsRelation input ● QueryNextGenEmailsWhereWhereConditions input ● QueryNextGenEmailsWhereWhereConditionsHasCondition input ● QueryNextGenEmailsWhereWhereConditionsRelation input ● QueryNextGenFormSubmissionsWhereWhereConditions input ● QueryNextGenFormSubmissionsWhereWhereConditionsHasCondition input ● QueryNextGenFormSubmissionsWhereWhereConditionsRelation input ● QueryNotificationsWhereWhereConditions input ● QueryNotificationsWhereWhereConditionsRelation input ● QueryOauthAppsWhereWhereConditions input ● QueryOauthAppsWhereWhereConditionsHasCondition input ● QueryOauthAppsWhereWhereConditionsRelation input ● QueryOnboardingCategoriesWhereWhereConditions input ● QueryOnboardingCategoriesWhereWhereConditionsHasCondition input ● QueryOnboardingCategoriesWhereWhereConditionsRelation input ● QueryOnboardingModulesWhereWhereConditions input ● QueryOnboardingModulesWhereWhereConditionsHasCondition input ● QueryOnboardingModulesWhereWhereConditionsRelation input ● QueryOnboardingTasksWhereWhereConditions input ● QueryOnboardingTasksWhereWhereConditionsHasCondition input ● QueryOnboardingTasksWhereWhereConditionsRelation input ● QueryOnboardingUserCompletedTasksWhereWhereConditions input ● QueryOnboardingUserCompletedTasksWhereWhereConditionsHasCondition input ● QueryOnboardingUserCompletedTasksWhereWhereConditionsRelation input ● QueryOpportunitiesWhereWhereConditions input ● QueryOpportunitiesWhereWhereConditionsHasCondition input ● QueryOpportunitiesWhereWhereConditionsRelation input ● QueryOpportunityCustomFieldsWhereWhereConditions input ● QueryOpportunityCustomFieldsWhereWhereConditionsHasCondition input ● QueryOpportunityCustomFieldsWhereWhereConditionsRelation input ● QueryOpportunityStageChangeActionsWhereWhereConditions input ● QueryOpportunityStageChangeActionsWhereWhereConditionsHasCondition input ● QueryOpportunityStageChangeActionsWhereWhereConditionsRelation input ● QueryOutflowingWorkflowNodeContactsWhereWhereConditions input ● QueryOutflowingWorkflowNodeContactsWhereWhereConditionsHasCondition input ● QueryOutflowingWorkflowNodeContactsWhereWhereConditionsRelation input ● QueryPackagesWhereWhereConditions input ● QueryPackagesWhereWhereConditionsHasCondition input ● QueryPackagesWhereWhereConditionsRelation input ● QueryPamingaLayoutTemplatesWhereWhereConditions input ● QueryPamingaLayoutTemplatesWhereWhereConditionsHasCondition input ● QueryPamingaLayoutTemplatesWhereWhereConditionsRelation input ● QueryPermissionsWhereWhereConditions input ● QueryPermissionsWhereWhereConditionsHasCondition input ● QueryPermissionsWhereWhereConditionsRelation input ● QueryPersonasWhereWhereConditions input ● QueryPersonasWhereWhereConditionsHasCondition input ● QueryPersonasWhereWhereConditionsRelation input ● QueryPromotionCodePoolsWhereWhereConditions input ● QueryPromotionCodePoolsWhereWhereConditionsHasCondition input ● QueryPromotionCodePoolsWhereWhereConditionsRelation input ● QueryQualifiedForWorkflowNodeWhereWhereConditions input ● QueryQualifiedForWorkflowNodeWhereWhereConditionsHasCondition input ● QueryQualifiedForWorkflowNodeWhereWhereConditionsRelation input ● QueryReportRecipientsWhereWhereConditions input ● QueryReportRecipientsWhereWhereConditionsHasCondition input ● QueryReportRecipientsWhereWhereConditionsRelation input ● QueryReportsWhereWhereConditions input ● QueryReportsWhereWhereConditionsHasCondition input ● QueryReportsWhereWhereConditionsRelation input ● QueryResubscribesWhereWhereConditions input ● QueryResubscribesWhereWhereConditionsHasCondition input ● QueryResubscribesWhereWhereConditionsRelation input ● QueryRolesWhereWhereConditions input ● QueryRolesWhereWhereConditionsHasCondition input ● QueryRolesWhereWhereConditionsRelation input ● QuerySalesforceIntegrationErrorsWhereWhereConditions input ● QuerySalesforceIntegrationErrorsWhereWhereConditionsHasCondition input ● QuerySalesforceIntegrationErrorsWhereWhereConditionsRelation input ● QuerySalesforceOpportunitiesWhereWhereConditions input ● QuerySalesforceOpportunitiesWhereWhereConditionsHasCondition input ● QuerySalesforceOpportunitiesWhereWhereConditionsRelation input ● QuerySegmentsWhereWhereConditions input ● QuerySegmentsWhereWhereConditionsHasCondition input ● QuerySegmentsWhereWhereConditionsRelation input ● QuerySmsMessagesWhereWhereConditions input ● QuerySmsMessagesWhereWhereConditionsHasCondition input ● QuerySmsMessagesWhereWhereConditionsRelation input ● QuerySocialMediaAccountsWhereWhereConditions input ● QuerySocialMediaAccountsWhereWhereConditionsHasCondition input ● QuerySocialMediaAccountsWhereWhereConditionsRelation input ● QuerySocialPostsWhereWhereConditions input ● QuerySocialPostsWhereWhereConditionsHasCondition input ● QuerySocialPostsWhereWhereConditionsRelation input ● QuerySubscriptionsWhereWhereConditions input ● QuerySubscriptionsWhereWhereConditionsHasCondition input ● QuerySubscriptionsWhereWhereConditionsRelation input ● QuerySugarIntegrationErrorsWhereWhereConditions input ● QuerySugarIntegrationErrorsWhereWhereConditionsHasCondition input ● QuerySugarIntegrationErrorsWhereWhereConditionsRelation input ● QuerySunsetContactWhereWhereConditions input ● QuerySunsetContactWhereWhereConditionsRelation input ● QuerySwoogoEventsWhereWhereConditions input ● QuerySwoogoEventsWhereWhereConditionsHasCondition input ● QuerySwoogoEventsWhereWhereConditionsRelation input ● QueryTasksWhereWhereConditions input ● QueryTasksWhereWhereConditionsHasCondition input ● QueryTasksWhereWhereConditionsRelation input ● QueryTeamsWhereWhereConditions input ● QueryTeamsWhereWhereConditionsHasCondition input ● QueryTeamsWhereWhereConditionsRelation input ● QueryThirdPartyEmailSendsWhereWhereConditions input ● QueryThirdPartyEmailSendsWhereWhereConditionsHasCondition input ● QueryThirdPartyEmailSendsWhereWhereConditionsRelation input ● QueryThirdPartyFormSubmissionsWhereWhereConditions input ● QueryThirdPartyFormSubmissionsWhereWhereConditionsHasCondition input ● QueryThirdPartyFormSubmissionsWhereWhereConditionsRelation input ● QueryThirdPartyFormsWhereWhereConditions input ● QueryThirdPartyFormsWhereWhereConditionsHasCondition input ● QueryThirdPartyFormsWhereWhereConditionsRelation input ● QueryTokensWhereWhereConditions input ● QueryTokensWhereWhereConditionsHasCondition input ● QueryTokensWhereWhereConditionsRelation input ● QueryToolTechnicAssetRegistrationWhereWhereConditions input ● QueryToolTechnicAssetRegistrationWhereWhereConditionsRelation input ● QueryUnsubscribesWhereWhereConditions input ● QueryUnsubscribesWhereWhereConditionsHasCondition input ● QueryUnsubscribesWhereWhereConditionsRelation input ● QueryUploadHistoryWhereWhereConditions input ● QueryUploadHistoryWhereWhereConditionsRelation input ● QueryUsersByTeamWhereWhereConditions input ● QueryUsersByTeamWhereWhereConditionsHasCondition input ● QueryUsersByTeamWhereWhereConditionsRelation input ● QueryUsersWhereWhereConditions input ● QueryUsersWhereWhereConditionsHasCondition input ● QueryUsersWhereWhereConditionsRelation input ● QueryViewsWhereWhereConditions input ● QueryViewsWhereWhereConditionsHasCondition input ● QueryViewsWhereWhereConditionsRelation input ● QueryVisitsWhereHasContactWhereHasConditions input ● QueryVisitsWhereHasContactWhereHasConditionsHasCondition input ● QueryVisitsWhereHasContactWhereHasConditionsRelation input ● QueryVisitsWhereWhereConditions input ● QueryVisitsWhereWhereConditionsHasCondition input ● QueryVisitsWhereWhereConditionsRelation input ● QueryWebinarsWhereWhereConditions input ● QueryWebinarsWhereWhereConditionsHasCondition input ● QueryWebinarsWhereWhereConditionsRelation input ● QueryWebsitePersonalizationsWhereWhereConditions input ● QueryWebsitePersonalizationsWhereWhereConditionsHasCondition input ● QueryWebsitePersonalizationsWhereWhereConditionsRelation input ● QueryWorkflowCompletionWhereWhereConditions input ● QueryWorkflowNodeQualificationsWhereWhereConditions input ● QueryWorkflowNodeQualificationsWhereWhereConditionsHasCondition input ● QueryWorkflowNodeQualificationsWhereWhereConditionsRelation input ● QueryWorkflowQualificationWhereWhereConditions input ● QueryWorkflowsEligibleForQualificationWhereWhereConditions input ● QueryWorkflowsEligibleForQualificationWhereWhereConditionsHasCondition input ● QueryWorkflowsEligibleForQualificationWhereWhereConditionsRelation input ● QueryWorkflowsWhereWhereConditions input ● QueryWorkflowsWhereWhereConditionsHasCondition input ● QueryWorkflowsWhereWhereConditionsRelation input ● WhereConditions input ● WhereConditionsHasCondition input ● WhereConditionsRelation input