Defining a query with the Text Manager (OP)
In an on-premises environment, use this procedure to define the selection criteria for a query through the Text Manager. The basic query properties for the query must be defined. See Defining a query.
Note: The functionality to define and run stand-alone SQL queries is not available
in a cloud environment.
Note that you can use the Text Manager to modify queries that were previously defined with Easy SQL. You can no longer maintain a query in Easy SQL, if you use one of the following in the query text.
- An OR boolean operator
- A BETWEEN predicate
- A HAVING clause
- Brackets
- Combined fields
- Wildcards
- Numeric expressions
- String expressions
To define the selection criteria for a query through the Text Manager: