|
CONTAINS(string, substring)
|
Returns true if the string contains the specified substring. e.g. CONTAINS('Hello World','World') returns true if filter or 1 for calculated column.
|
|
ENDSWITH(string, substring)
|
Returns true if the string ends with the specified substring. E.g. ENDSWITH('Hello World', 'ld') returns true for filters or 1 for calculated columns.
|
|
IFNULL(value, default_value)
|
Returns the value if it is not null, otherwise the default_value is returned. Argument types for value and default_value must match. e.g. IFNULL([ShipVia],2) -if ShipVia is null then 2 is returned otherwise the value of ShipVia is returned.
|
|
IIF(expression, true_part, false_part)
|
Returns the true_part if the boolean expression is true, otherwise the false_part is returned. E.g. IIF(45 > 40, 'big', 'small') returns 'big'.
|
|
INLIST(test_value, value1, ... valueN)
|
Returns true if the specified value matches any in the list. e.g. INLIST(4, 3, 5, 6, 4) returns true for a filter or 1 for a calculated column. Sample: INLIST([ShipVIA],1,2,3).
|
|
ISNULL(value)
|
Returns true if the value is null, false if it contains any value. e.g. ISNULL([ShipRegion]) returns true or false for filters and 0 or 1 for calculated columns.
|
|
STARTSWITH(string, substring)
|
Returns true if the string begins with the specified substring. E.g. STARTSWITH('Hello World', 'He') returns true for filters or 1 for calculated columns.
|
The functions listed in the table below are for SQL queries and should not be used with inline scripts.