Criteria Language Syntax

DateTime

#

Date and time comparison values.

Enumeration

Enumeration comparison values. To specify an enumeration value in criteria, use its name enclosed in apostrophes:

• Status = 'InProgress'
  • If an enumeration value has an initializer, you can use the initializer value: 
• Status = 1
  • Note that you cannot specify an enumeration value via its qualified name. So, the following criteria is incorrect: 
• Status = Status.InProgress

Guid

{}

Guid comparison values. A Guid may only be used in a relational operation with equality or inequality operators.

Numeric

Numeric comparison values.

String

'

String comparison values.

Avg

Evaluates an average of all values in a collection.

Accounts.Avg(Amount) = 75

Count

Returns the number of objects in a collection.

Accounts.Count > 1

Exists

Determines whether a collection property contains objects.

Accounts.Exists

Max

Returns the maximum expression value in a collection.

Accounts.Max(Amount) > 75

Min

Returns the minimum expression value in a collection.

Accounts.Min(Amount) < 10

Sum

Returns a sum of all expression values in a collection.

Accounts.Sum(Amount) > 150

BitwiseAnd

Represents the bitwise AND operator.

Roles & 1 = 1

BitwiseOr

Represents the bitwise OR operator.

Roles | 253 = 255

BitwiseXor

Represents the bitwise XOR operator.

Roles ^ 253 = 255

Divide

Represents the division operator.

Accounts.Max(Amount) / Accounts.Min(Amount) > 10

Equal

Represents the Boolean equality operator.

Name = 'John'

Greater

Represents the Boolean greater-than operator.

Age > 20

GreaterOrEqual

Represents the Boolean greater-than-or-equal-to operator.

Age >= 20

Less

Represents the Boolean less-than operator.

Age < 20

LessOrEqual

Represents the Boolean less-than-or-equal-to operator.

Age <= 20

Like

Represents the LIKE operator that determines whether a specific character string matches a specified pattern. The following wildcard characters are supported:

• % matches a string of zero or more characters. For instance:
  • Name like 'Jo%'") - returns all the objects whose Name begins with 'Jo'.
  • Name like '%car%'") - returns all the objects whose Name contains the 'car' substring.
• _ matches a single character. For instance:
  • Name like 'car_'") - returns all the objects whose Name consists of four characters, and begins with 'car'.
• [ ] identifies a single character within the specified range ([a-c]) or set ([abc]). For instance:
  • Name like '[A-C]%'") - returns all the objects whose Name begins with 'A', 'B' or 'C'.
• [^] excludes a single character not within the specified range ([^a-c]) or set ([^abc]). For instance:
  • Name like 're[^de]%'") - returns all the objects whose Name begins with 're', and where the following letter is not 'd' or 'e'.

Name like 'Jo%' or Name like '%ob'

Minus

Represents the subtraction operator.

Age - 30 > 0

Modulo

Represents the modulus operator (computes the remainder after dividing its first operand by its second).

Age % 50 = 0

Multiply

Represents the multiplication operator.

Accounts.Sum(Amount) * 20 >= 3000

NotEqual

Represents the Boolean inequality operator.

Name != 'John'

Plus

Represents the addition operator. Note: You can also use this operator to concatenate strings.

Age + 50 = 100
Name + ToStr(Age)

Concat

Concatenates one or more strings.

Name like Concat('%J', 'o%')

Iif

Returns one of two values depending upon the value of a logical expression. The function requires three operands:

1. determines the logical expression; 
2. specifies the value that will be returned if the logical expression evaluates to true; 
3. specifies the value that will be returned if the logical expression evaluates to false.

(Iif (Accounts.Sum(Amount) > 150, 1, 0) = 1)

IsNull

Compares the first operand with the null value. This function requires one or two operands. The value returned depends upon the number of arguments.

• If a single argument is passed, the function returns true if the operand is null, otherwise, false is returned. 
• If two operands are passed, the function returns the second operand if the first operand is null, otherwise, the first operand is returned.

IsNull(Name)

Len

Returns the length of the string specified by an operand.

Len(Name) > 3

Lower

Converts all characters in a string operand to lowercase.

Lower(Name) like '%jo%'

Substring

Returns a substring extracted from the specified string. If two operands are passed the substring will be extracted from the beginning of the original string. The operands should be defined as follows:

1. an original string; 
2. an integer that specifies the length of the substring.
   If three operands are passed, a substring can be subtracted starting from any position in the original string. The operands should be defined as follows: 
   
3. an original string; 
4. an integer that specifies the zero-based index at which the substring to return begins; 
5. an integer that specifies the length of the substring.

Substring(Name, 0, 2) = 'Bo'

Trim

Returns a string containing a copy of a specified string with no leading or trailing spaces. This function requires a single operand that refers to the original string.

Trim(Name) = 'Bob'

Upper

Converts all characters in a string operand to uppercase.

Upper(Name) like '%JO%'

And

Groups operands with logical AND.

Name = 'John' and Age = 30

Or

Groups operands with logical OR.

Name = 'John' or Age = 30

BitwiseNot

Represents the bitwise NOT operator.

~Roles = 251

IsNull

Represents the operator which determines whether or not a given expression is NULL.

Name is null

Minus

Represents the unary negation (-) operator.

-Age = -20

Not

Represents the logical NOT.

not (Name = 'John' or Age = 30)

Plus

Represents the unary plus (+) operator.

Age = +10

Between

Determines whether the expression lies between the specified range of values.

Age between (20, 40)

In

Determines whether a value matches any value in the specified list.

Name in ('John', 'Bob', 'Nick')