SQLOperator

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

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

Values​

SQLOperator.EQ​

Equal operator (=)

SQLOperator.NEQ​

Not equal operator (!=)

SQLOperator.GT​

Greater than operator (>)

SQLOperator.GTE​

Greater than or equal operator (>=)

SQLOperator.LT​

Less than operator (<)

SQLOperator.LTE​

Less than or equal operator (<=)

SQLOperator.LIKE​

Simple pattern matching (LIKE)

SQLOperator.NOT_LIKE​

Negation of simple pattern matching (NOT LIKE)

SQLOperator.IN​

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

SQLOperator.NOT_IN​

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

SQLOperator.BETWEEN​

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

SQLOperator.NOT_BETWEEN​

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

SQLOperator.IS_NULL​

Whether a value is null (IS NULL)

SQLOperator.IS_NOT_NULL​

Whether a value is not null (IS NOT NULL)

Member Of​

ActContractsWhereWhereConditions input ● ActFilesWhereWhereConditions input ● ActInvoicesWhereWhereConditions input ● ActLettersWhereWhereConditions input ● ActMetersWhereWhereConditions input ● ActProjectsWhereWhereConditions input ● ActPropertiesWhereWhereConditions input ● ActQuotesWhereWhereConditions input ● ActTasksWhereWhereConditions input ● CompanyContactsWhereWhereConditions input ● CompanyContractsWhereWhereConditions input ● CompanyCoordinationsWhereWhereConditions input ● CompanyEmailsWhereWhereConditions input ● CompanyFilesWhereWhereConditions input ● CompanyLettersWhereWhereConditions input ● CompanyLinkedinsWhereWhereConditions input ● CompanyMembersWhereWhereConditions input ● CompanyMetersWhereWhereConditions input ● CompanyPeopleWhereWhereConditions input ● CompanyPhonesWhereWhereConditions input ● CompanyProjectsWhereWhereConditions input ● CompanyPropertiesWhereWhereConditions input ● CompanySpecificationsWhereWhereConditions input ● CompanySubmissionsWhereWhereConditions input ● CompanyTagsWhereWhereConditions input ● CompanyTasksWhereWhereConditions input ● CompanyWebsitesWhereWhereConditions input ● ContactActsWhereWhereConditions input ● ContactCompaniesWhereWhereConditions input ● ContactContactsWhereWhereConditions input ● ContactContractsWhereWhereConditions input ● ContactCoordinationsWhereWhereConditions input ● ContactEmailsWhereWhereConditions input ● ContactExpensesWhereWhereConditions input ● ContactFilesWhereWhereConditions input ● ContactInvoicesWhereWhereConditions input ● ContactLettersWhereWhereConditions input ● ContactLinkedinsWhereWhereConditions input ● ContactMembersWhereWhereConditions input ● ContactMetersWhereWhereConditions input ● ContactPeopleWhereWhereConditions input ● ContactPhonesWhereWhereConditions input ● ContactProjectsWhereWhereConditions input ● ContactPropertiesWhereWhereConditions input ● ContactQuotesWhereWhereConditions input ● ContactSpecificationsWhereWhereConditions input ● ContactStructuresWhereWhereConditions input ● ContactSubmissionsWhereWhereConditions input ● ContactTagsWhereWhereConditions input ● ContactTasksWhereWhereConditions input ● ContactWebsitesWhereWhereConditions input ● ContractActsWhereWhereConditions input ● ContractChildrenWhereWhereConditions input ● ContractContactsWhereWhereConditions input ● ContractExpensesWhereWhereConditions input ● ContractFilesWhereWhereConditions input ● ContractInvoicesWhereWhereConditions input ● ContractLettersWhereWhereConditions input ● ContractMembersWhereWhereConditions input ● ContractMetersWhereWhereConditions input ● ContractProjectsWhereWhereConditions input ● ContractPropertiesWhereWhereConditions input ● ContractQuotesWhereWhereConditions input ● ContractTagsWhereWhereConditions input ● ContractTasksWhereWhereConditions input ● CoordinationContactsWhereWhereConditions input ● CoordinationFilesWhereWhereConditions input ● CoordinationLettersWhereWhereConditions input ● CoordinationMembersWhereWhereConditions input ● CoordinationProjectsWhereWhereConditions input ● CoordinationPropertiesWhereWhereConditions input ● CoordinationSpecificationsWhereWhereConditions input ● CoordinationTagsWhereWhereConditions input ● CoordinationTasksWhereWhereConditions input ● CorrespondenceContactsWhereWhereConditions input ● CorrespondenceContractsWhereWhereConditions input ● CorrespondenceCoordinationsWhereWhereConditions input ● CorrespondenceEasementsWhereWhereConditions input ● CorrespondenceMembersWhereWhereConditions input ● CorrespondenceOrdinancesWhereWhereConditions input ● CorrespondenceProjectsWhereWhereConditions input ● CorrespondencePropertiesWhereWhereConditions input ● CorrespondenceSpecificationsWhereWhereConditions input ● CorrespondenceSubmissionsWhereWhereConditions input ● CorrespondenceTasksWhereWhereConditions input ● EasementFilesWhereWhereConditions input ● EasementLettersWhereWhereConditions input ● EasementMembersWhereWhereConditions input ● EasementProjectsWhereWhereConditions input ● EasementPropertiesWhereWhereConditions input ● EasementStructuresWhereWhereConditions input ● EasementTasksWhereWhereConditions input ● ExpenseContractsWhereWhereConditions input ● ExpenseFilesWhereWhereConditions input ● ExpenseLettersWhereWhereConditions input ● ExpenseProjectsWhereWhereConditions input ● ExpensePropertiesWhereWhereConditions input ● ExpenseStructuresWhereWhereConditions input ● ExpenseTasksWhereWhereConditions input ● InvoiceContractsWhereWhereConditions input ● InvoiceFilesWhereWhereConditions input ● InvoiceLettersWhereWhereConditions input ● InvoiceProjectsWhereWhereConditions input ● InvoicePropertiesWhereWhereConditions input ● InvoiceSpecificationsWhereWhereConditions input ● InvoiceStructuresWhereWhereConditions input ● InvoiceTasksWhereWhereConditions input ● LetterActsWhereWhereConditions input ● LetterContactsWhereWhereConditions input ● LetterContractsWhereWhereConditions input ● LetterCoordinationsWhereWhereConditions input ● LetterEasementsWhereWhereConditions input ● LetterExpensesWhereWhereConditions input ● LetterFilesWhereWhereConditions input ● LetterInvoicesWhereWhereConditions input ● LetterMembersWhereWhereConditions input ● LetterMetersWhereWhereConditions input ● LetterOrdinancesWhereWhereConditions input ● LetterProjectsWhereWhereConditions input ● LetterPropertiesWhereWhereConditions input ● LetterQuotesWhereWhereConditions input ● LetterSpecificationsWhereWhereConditions input ● LetterStructuresWhereWhereConditions input ● LetterSubmissionsWhereWhereConditions input ● LetterTasksWhereWhereConditions input ● MeterActsWhereWhereConditions input ● MeterChildrenWhereWhereConditions input ● MeterContactsWhereWhereConditions input ● MeterContractsWhereWhereConditions input ● MeterFilesWhereWhereConditions input ● MeterLettersWhereWhereConditions input ● MeterReadingsWhereWhereConditions input ● MeterSpecificationsWhereWhereConditions input ● MeterSubmissionsWhereWhereConditions input ● MeterTagsWhereWhereConditions input ● MeterTasksWhereWhereConditions input ● NumberingSeriesChildrenWhereWhereConditions input ● OrdinanceChildrenWhereWhereConditions input ● OrdinanceFilesWhereWhereConditions input ● OrdinanceLettersWhereWhereConditions input ● OrdinanceMembersWhereWhereConditions input ● OrdinanceProjectsWhereWhereConditions input ● OrdinanceTasksWhereWhereConditions input ● PersonCompaniesWhereWhereConditions input ● PersonContactsWhereWhereConditions input ● PersonContractsWhereWhereConditions input ● PersonCoordinationsWhereWhereConditions input ● PersonEmailsWhereWhereConditions input ● PersonFilesWhereWhereConditions input ● PersonLettersWhereWhereConditions input ● PersonLinkedinsWhereWhereConditions input ● PersonMembersWhereWhereConditions input ● PersonMetersWhereWhereConditions input ● PersonPhonesWhereWhereConditions input ● PersonProjectsWhereWhereConditions input ● PersonPropertiesWhereWhereConditions input ● PersonSpecificationsWhereWhereConditions input ● PersonSubmissionsWhereWhereConditions input ● PersonTagsWhereWhereConditions input ● PersonTasksWhereWhereConditions input ● PersonWebsitesWhereWhereConditions input ● ProductGroupChildrenWhereWhereConditions input ● ProjectActsWhereWhereConditions input ● ProjectChildrenWhereWhereConditions input ● ProjectContactsWhereWhereConditions input ● ProjectContractsWhereWhereConditions input ● ProjectCoordinationsWhereWhereConditions input ● ProjectEasementsWhereWhereConditions input ● ProjectExpensesWhereWhereConditions input ● ProjectFilesWhereWhereConditions input ● ProjectInvoicesWhereWhereConditions input ● ProjectLettersWhereWhereConditions input ● ProjectMembersWhereWhereConditions input ● ProjectOrdinancesWhereWhereConditions input ● ProjectPropertiesWhereWhereConditions input ● ProjectQuotesWhereWhereConditions input ● ProjectSpecificationsWhereWhereConditions input ● ProjectStructuresWhereWhereConditions input ● ProjectSubmissionsWhereWhereConditions input ● ProjectTagsWhereWhereConditions input ● ProjectTasksWhereWhereConditions input ● PropertyActsWhereWhereConditions input ● PropertyContactsWhereWhereConditions input ● PropertyContractsWhereWhereConditions input ● PropertyCoordinationsWhereWhereConditions input ● PropertyEasementsWhereWhereConditions input ● PropertyExpensesWhereWhereConditions input ● PropertyFilesWhereWhereConditions input ● PropertyInvoicesWhereWhereConditions input ● PropertyLettersWhereWhereConditions input ● PropertyMembersWhereWhereConditions input ● PropertyMetersWhereWhereConditions input ● PropertyOwnersWhereWhereConditions input ● PropertyProjectsWhereWhereConditions input ● PropertyQuotesWhereWhereConditions input ● PropertyReadingsWhereWhereConditions input ● PropertyRepresentativesWhereWhereConditions input ● PropertySpecificationsWhereWhereConditions input ● PropertyStructuresWhereWhereConditions input ● PropertySubmissionsWhereWhereConditions input ● PropertyTagsWhereWhereConditions input ● PropertyTasksWhereWhereConditions input ● QueryAccessTokensWhereWhereConditions input ● QueryActivitiesWhereWhereConditions input ● QueryActsWhereWhereConditions input ● QueryActTypesWhereWhereConditions input ● QueryApprovalsWhereWhereConditions input ● QueryBundleTasksWhereWhereConditions input ● QueryClientsWhereWhereConditions input ● QueryCommentsWhereWhereConditions input ● QueryCompaniesWhereWhereConditions input ● QueryContactsWhereWhereConditions input ● QueryContractsWhereWhereConditions input ● QueryContractTypesWhereWhereConditions input ● QueryCoordinationGroupsWhereWhereConditions input ● QueryCoordinationStagesWhereWhereConditions input ● QueryCoordinationsWhereWhereConditions input ● QueryCoordinationTypesWhereWhereConditions input ● QueryCorrespondencesWhereWhereConditions input ● QueryDashboardsWhereWhereConditions input ● QueryEasementsWhereWhereConditions input ● QueryEasementTypesWhereWhereConditions input ● QueryESigningsWhereWhereConditions input ● QueryExpensesWhereWhereConditions input ● QueryFilesWhereWhereConditions input ● QueryInvoicesWhereWhereConditions input ● QueryJobLogsWhereWhereConditions input ● QueryLetterSourcesWhereWhereConditions input ● QueryLettersWhereWhereConditions input ● QueryLetterTypesWhereWhereConditions input ● QueryMeterManufacturersWhereWhereConditions input ● QueryMeterModelsWhereWhereConditions input ● QueryMeterNominalValuesWhereWhereConditions input ● QueryMetersWhereWhereConditions input ● QueryNumberingFunctionsWhereWhereConditions input ● QueryNumberingSetsWhereWhereConditions input ● QueryOrdinancesWhereWhereConditions input ● QueryOrdinanceTypesWhereWhereConditions input ● QueryPeopleWhereWhereConditions input ● QueryPriceListsWhereWhereConditions input ● QueryProductGroupsWhereWhereConditions input ● QueryProductsWhereWhereConditions input ● QueryProjectsWhereWhereConditions input ● QueryPropertiesWhereWhereConditions input ● QueryQuotesWhereWhereConditions input ● QueryReadingsWhereWhereConditions input ● QueryRecurringTasksWhereWhereConditions input ● QueryRolesWhereWhereConditions input ● QuerySpecificationsWhereWhereConditions input ● QuerySpecificationTypesWhereWhereConditions input ● QueryStatusesWhereWhereConditions input ● QueryStructuresWhereWhereConditions input ● QuerySubmissionSourcesWhereWhereConditions input ● QuerySubmissionsWhereWhereConditions input ● QuerySubmissionTypesWhereWhereConditions input ● QueryTagsWhereWhereConditions input ● QueryTaskBundlesWhereWhereConditions input ● QueryTasksWhereWhereConditions input ● QueryTaskTypesWhereWhereConditions input ● QueryTaxRatesWhereWhereConditions input ● QueryTemplatesWhereWhereConditions input ● QueryUsersWhereWhereConditions input ● QueryViewsWhereWhereConditions input ● QueryWebhooksWhereWhereConditions input ● QuoteActsWhereWhereConditions input ● QuoteContractsWhereWhereConditions input ● QuoteFilesWhereWhereConditions input ● QuoteInvoicesWhereWhereConditions input ● QuoteLettersWhereWhereConditions input ● QuoteProjectsWhereWhereConditions input ● QuotePropertiesWhereWhereConditions input ● QuoteStructuresWhereWhereConditions input ● QuoteTasksWhereWhereConditions input ● SpecificationContactsWhereWhereConditions input ● SpecificationCoordinationsWhereWhereConditions input ● SpecificationFilesWhereWhereConditions input ● SpecificationInvoicesWhereWhereConditions input ● SpecificationLettersWhereWhereConditions input ● SpecificationMembersWhereWhereConditions input ● SpecificationMetersWhereWhereConditions input ● SpecificationProjectsWhereWhereConditions input ● SpecificationPropertiesWhereWhereConditions input ● SpecificationSubmissionsWhereWhereConditions input ● SpecificationTagsWhereWhereConditions input ● SpecificationTasksWhereWhereConditions input ● StructureContactsWhereWhereConditions input ● StructureEasementsWhereWhereConditions input ● StructureExpensesWhereWhereConditions input ● StructureFilesWhereWhereConditions input ● StructureInvoicesWhereWhereConditions input ● StructureLettersWhereWhereConditions input ● StructureMetersWhereWhereConditions input ● StructureProjectsWhereWhereConditions input ● StructureQuotesWhereWhereConditions input ● StructureTagsWhereWhereConditions input ● StructureTasksWhereWhereConditions input ● SubmissionContactsWhereWhereConditions input ● SubmissionFilesWhereWhereConditions input ● SubmissionLettersWhereWhereConditions input ● SubmissionMembersWhereWhereConditions input ● SubmissionMetersWhereWhereConditions input ● SubmissionProjectsWhereWhereConditions input ● SubmissionPropertiesWhereWhereConditions input ● SubmissionSpecificationsWhereWhereConditions input ● SubmissionTagsWhereWhereConditions input ● SubmissionTasksWhereWhereConditions input ● TaskActsWhereWhereConditions input ● TaskBundleTasksWhereWhereConditions input ● TaskChildrenWhereWhereConditions input ● TaskContactsWhereWhereConditions input ● TaskContractsWhereWhereConditions input ● TaskCoordinationsWhereWhereConditions input ● TaskEasementsWhereWhereConditions input ● TaskExpensesWhereWhereConditions input ● TaskFilesWhereWhereConditions input ● TaskInvoicesWhereWhereConditions input ● TaskLettersWhereWhereConditions input ● TaskMembersWhereWhereConditions input ● TaskMetersWhereWhereConditions input ● TaskOrdinancesWhereWhereConditions input ● TaskProjectsWhereWhereConditions input ● TaskPropertiesWhereWhereConditions input ● TaskQuotesWhereWhereConditions input ● TaskSpawnedTasksWhereWhereConditions input ● TaskSpecificationsWhereWhereConditions input ● TaskStructuresWhereWhereConditions input ● TaskSubmissionsWhereWhereConditions input ● UserCompaniesWhereWhereConditions input ● UserContactsWhereWhereConditions input ● UserPeopleWhereWhereConditions input ● UserPhonesWhereWhereConditions input ● UserProjectsWhereWhereConditions input ● WebhookLogsWhereWhereConditions input ● WhereConditions input ● WhereConditionsHasCondition input ● WhereConditionsRelation input