The contains() function tests whether a String attribute contains a specific string as a substring.
This query returns all customers from which the name contains the string ‘an’. Customers with the name ‘Jansen’ or ‘Jans’ will be returned, because ‘an’ is part of the names ‘Jansen’ and ‘Jans’.
Search with special characters (like
\) is not supported in Mendix 5. Please upgrade to Mendix 7.11 or higher if you want to search with special characters.