|%||the remainder after division|
Concatenation, joining strings
Example: Fields.FirstName + " " + Fields.LastName.
|<=||less than or equal to|
|<>||not equal to|
|>=||greater than or equal to|
|Between||selects a range of data between two values|
|In||Compare to a list of items. The list can be a any collection of objects|
|IS [NOT] NULL|
If the value of expression is NULL, IS NULL returns TRUE; otherwise, it returns FALSE.
If the value of expression is NULL, IS NOT NULL returns FALSE; otherwise, it returns TRUE.
Null values represent missing unknown data and are usually used as placeholders for unknown or inapplicable values. It is not possible to test for null values with comparison operators such as = or <>. The IS [NOT] NULL operator should be used instead.
|And||Combines two Boolean expressions and returns TRUE when both expressions are TRUE|
|Not||Using NOT negates an expression|
|Or||Combines two Boolean expressions and returns TRUE when either of the conditions is TRUE|
|?:||Conditional operator. Returns one of two values depending on the value of a Boolean expression. Usage: =Fields.DiscountAvailable ? Fields.X : Fields.Y|
|??||Null-coalescing operator. Returns the left-hand operand if the operand is not null; otherwise it returns the right hand operand. Usage: =Fields.Description ?? "N/A"|
Both the * and % can be used interchangeably for wildcard characters in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be escaped in brackets (). If a bracket is in the clause, the bracket characters should be escaped in brackets (for example [ or [&cd;). A wildcard is allowed at the start and end of a pattern, or at the end of a pattern, or at the start of a pattern. For example:
- "ItemName LIKE '*product*'"
- "ItemName LIKE '*product'"
- "ItemName LIKE 'product*'"
Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.