Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support until July, 2024.

OQL Where Clause

Last modified: August 2, 2022

The WHERE clause specifies how the data being retrieved must be constrained.

The syntax is as following:

WHERE <constraint>

<constraint> An expression for which the value always equals true. Expressions consist of simple comparables with operators, functions, keywords or system variables.

1
2


SELECT FirstName FROM Sales.Customer
WHERE LastName = 'Jansen'

This query retrieves all customers whose name is equal to ‘Jansen’.

1
2
3


SELECT FirstName FROM Sales.Customer
INNER JOIN Sales.Customer/Sales.Customer_Address/Sales.Address
WHERE Sales.Address/City = 'Rotterdam'

This query retrieves all customers who live in ‘Rotterdam’.