If you would like to upgrade to a newer long-term support version of Studio Pro, see Moving from Mendix Studio Pro 8 to 9.

Relational Expressions

Last modified: August 27, 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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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

Is 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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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
```

Is 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

The two values should be in the same category (for example, if one is numeric, the other should be numeric too).

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