Validation
ISALPHA
❌ Cannot be used in filter queries
Checks if the input text contains only letters (a-zA-Z).
Syntax
ISALPHA(text, locale)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
locale | optional | Locale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "sr-RS@latin", "sv-SE", "tr-TR", "uk-UA". Defaults to en-US. |
ISALPHANUM
❌ Cannot be used in filter queries
Checks if the input text contains only letters and numbers (a-zA-Z0-9)
Syntax
ISALPHANUM(text, locale)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
locale | optional | Locale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "sr-RS@latin", "sv-SE", "tr-TR", "uk-UA". Defaults to en-US |
ISARRAY
❌ Cannot be used in filter queries
Checks if the input is an array (list of values) or not.
Syntax
ISARRAY(value)
Name | Type | Description |
---|---|---|
value | mandatory | Can be any valid expression as long as it resolves to an object value. |
ISASCII
❌ Cannot be used in filter queries
Checks if the input text contains ASCII chars only or not.
Syntax
ISASCII(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISBIC
❌ Cannot be used in filter queries
Checks if the input text is a BIC (Bank Identification Code) or SWIFT code or not.
Syntax
ISBIC(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISBOOLEAN
❌ Cannot be used in filter queries
Checks if the input text is a boolean or not.
Syntax
ISBOOLEAN(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISCREDITCARD
❌ Cannot be used in filter queries
Checks if the input text is a credit card number or not.
Syntax
ISCREDITCARD(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISDATE
❌ Cannot be used in filter queries
Checks if the input text is a valid date (in ISO 8601 or RFC 2822 format) or not.
Syntax
ISDATE(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISDECIMAL
❌ Cannot be used in filter queries
Checks if the input text is decimal number (such as 0.25, .4, 3,56, 2.00065, 12.0) or not.
Syntax
ISDECIMAL(text, locale)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
locale | optional | Locale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "sr-RS@latin", "sv-SE", "tr-TR", "uk-UA". Defaults to en-US |
ISEMAIL
❌ Cannot be used in filter queries
Checks if the input text is an email address or not.
Syntax
ISEMAIL(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISEMPTY
❌ Cannot be used in filter queries
Checks if the input text has any value or not.
Syntax
ISEMPTY(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISIBAN
❌ Cannot be used in filter queries
Checks if the input text is an IBAN (International Bank Account Number) or not.
Syntax
ISIBAN(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISIMEI
❌ Cannot be used in filter queries
Checks if the input text is a valid IMEI (International Mobile Equipment Identity) number or not.
Syntax
ISIMEI(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISINTEGER
❌ Cannot be used in filter queries
Checks if the input text is an integer or not.
Syntax
ISINTEGER(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISIP
❌ Cannot be used in filter queries
Checks if the input text is an IP address (version 4 or 6) or not.
Syntax
ISIP(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISISBN
❌ Cannot be used in filter queries
Checks if the input text is an ISBN (International Standard Book Number version 10 or 13) or not.
Syntax
ISISBN(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISISRC
❌ Cannot be used in filter queries
Checks if the input text is an ISRC (International Standard Recording Code) or not.
Syntax
ISISRC(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISISSN
❌ Cannot be used in filter queries
Checks if the input text is an ISSN (International Standard Serial Number) or not.
Syntax
ISISSN(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISLOWERCASE
❌ Cannot be used in filter queries
Checks if the input text is lowercase or not.
Syntax
ISLOWERCASE(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISMACADDRESS
❌ Cannot be used in filter queries
Checks if the input text is a MAC (media access control) address or not.
Syntax
ISMACADDRESS(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISMOBILEPHONE
❌ Cannot be used in filter queries
Checks if the input text is a mobile phone number (with a "+" and a country code, e.g., +12345678901 in E.164 format) or not.
Syntax
ISMOBILEPHONE(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISNUMERIC
❌ Cannot be used in filter queries
Checks if the input text contains only numbers or not.
Syntax
ISNUMERIC(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISOBJECT
❌ Cannot be used in filter queries
Checks if the input is an object or not.
Syntax
ISOBJECT(value)
Name | Type | Description |
---|---|---|
value | mandatory | Can be any valid expression as long as it resolves to an object value. |
ISSTRONGPWD
❌ Cannot be used in filter queries
Checks if the input password is strong by checking whether it includes the minimum number of lowercase, uppercase letters, numbers, and symbols. Returns true if the password meets the minimum requirements, otherwise returns false.
Syntax
ISSTRONGPWD(password, minLength, minLowercase, minUppercase, minNumbers, minSymbols)
Name | Type | Description |
---|---|---|
password | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
minLength | mandatory | Minimum length of the password. Can be any expression as long as it resolves to an integer value. |
minLowercase | mandatory | Minimum number of lowercase letters. Can be any expression as long as it resolves to an integer value. |
minUppercase | mandatory | Minimum number of uppercase letters. Can be any expression as long as it resolves to an integer value. |
minNumbers | mandatory | Minimum number of numbers. Can be any expression as long as it resolves to an integer value. |
minSymbols | mandatory | Minimum number of symbols. Can be any expression as long as it resolves to an integer value. |
ISUPPERCASE
❌ Cannot be used in filter queries
Checks if the input text is uppercase or not.
Syntax
ISUPPERCASE(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |
ISURL
❌ Cannot be used in filter queries
Checks if the input text is a URL or not.
Syntax
ISURL(text)
Name | Type | Description |
---|---|---|
text | mandatory | Can be any valid expression as long as it resolves to a text/string value. |