Greyfinch Help Center
Sign in
API Reference

CitextComparisonExp

Input type

Boolean expression to compare columns of type "citext". All fields are combined with logical 'AND'.

Fields

· 19
_eq citext
_gt citext
_gte citext
_ilike citext
_in [citext!]
_iregex citext
_isNull Boolean
_like citext
_lt citext
_lte citext
_neq citext
_nilike citext
_nin [citext!]
_niregex citext
_nlike citext
_nregex citext
_nsimilar citext
_regex citext
_similar citext

Used by

· 35 operations
QUERY appCompaniesQUERY appsQUERY connectionsQUERY outboundNumbersQUERY leadConfigurationSettingsQUERY leadConfigurationsQUERY leadsQUERY companiesQUERY divisionsQUERY locationsQUERY resourcesQUERY usersQUERY appointmentBookingsQUERY appointmentTemplatesQUERY appointmentTypesQUERY appointmentsQUERY documentsQUERY imageDocumentLinksQUERY imageSeriesQUERY imagesQUERY insuranceSubscriptionsQUERY patientsQUERY treatmentsMUTATION sendSmsMUTATION createPatientFromLeadMUTATION insertLeadMUTATION insertLeadConfigurationMUTATION insertLeadConfigurationSettingMUTATION insertDocumentFileMUTATION insertDocumentFolderMUTATION insertDocumentVirtualMUTATION insertImageDocumentInternalMUTATION insertImageDocumentLinkMUTATION insertImageDocumentLinkOneMUTATION insertPersonRelationship

Referenced by types

· 2
ConnectionBoolExp.usernameUserBoolExp.email