KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: ORDA string query with "@" as a literal character
PRODUCT: 4D | VERSION: 19 | PLATFORM: Mac & Win
Published On: June 6, 2022

When performing an ORDA string query, usually the “@“ character is considered as a wildcard in the search criteria. Sometimes the “@“ character must be considered as a literal character, such as in a query for an email address. To consider “@“ as a literal character, use the “===“ comparison operator in the query string. For example, given a People table with email field storing email addresses:

$entitySel:=ds.People.query("email === :1"; “hello@world.com")

In the above ORDA query, the “@“ character will not be treated as a wildcard. The query will return an entity selection of People with email address that matches “hello@world.com” exactly.