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"; “firstname.lastname@example.org")|
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 “email@example.com” exactly.