Mendix 7 is no longer supported unless you have Extended Support. Mendix 7 documentation will remain available until July 2024.

To upgrade to a supported version, see Moving from Desktop Modeler Version 7 to Studio Pro 8.

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’.