Relational Expressions

Last modified: September 5, 2024

Introduction

Relational expressions allow users to compare values and to make changes and perform actions based upon that information. The return type of such expressions is always Boolean.

Less Than ( < )

This expression determines whether the first value is less than the second value.

Input Parameters

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time

Output

The output is described in the table below:

Value Type
True or False. Boolean

Example

If you use the following input:

4<3

the output is:

False

Greater Than ( > )

This expression determines whether the first value is greater than the second value.

Input Parameters

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time

Output

The output is described in the table below:

Value Type
True or False. Boolean

Example

If you use the following input:

4>3

the output is:

True

Less Than or Equal To ( <= )

This expression determines whether the first value is less than or equal to the second value.

Input Parameters

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time

Output

The output is described in the table below:

Value Type
True or False. Boolean

Examples

The examples below illustrate which value the expression returns:

  • If you use the following input:

    6<=3

    the output is:

    False

  • If you use the following input:

    3<=3

    the output is:

    True

Greater Than or Equal To ( >= )

Determines whether the first value is greater than or equal to the second.

Input Parameters

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time

Output

The output is described in the table below:

Value Type
True or False. Boolean

Example

If you use the following input:

4>=3

the output is:

True

Equal To ( = )

This expression determines whether the two values are equal.

Input Parameters

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time
Two values Domain entity; equality is checked based on the ID of the object

Output

The output is described in the table below:

Value Type
True or False. Boolean

Examples

The examples below illustrate which value the expression returns:

  • If you use the following input:

    "mystring" = "myotherstring"

    the output is:

    False

  • If you use the following input:

    dateTime(2007) = dateTime(2007)

    the output is:

    True

Not Equal To ( != )

Determines whether the two values are not equal.

Input Parameters

The values be any of the following types, but the two values should be in the same category (for example, both numbers):

Possible values are described in the table below:

Value Type
Two values String
Two values Numeric (Integer/Long, Decimal)
Two values Date and time
Two values Object; equality is checked based on the ID of the object

Output

The output is described in the table below:

Value Type
True or False. Boolean

Example

If you use the following input:

"mystring" != "mystring"

the output is:

False