eSQL – Reference
Overview of eSQL Keywords
Reserved keywords, operators, and functions are analyzed syntactically by the parser and may therefore not be used as names for types, fields, etc., except if they are masked.
In the following you will find differently sorted overviews of all keywords that eSQL supports.
Keyword/operator/function | Description |
|---|---|
| Relational operators |
| Arithmetical operators |
| Wildcard |
| Column query operator |
| Identifies all values with removing duplicates. |
| Inactive versions of object types are included in the query. |
| Combines two conditions and returns TRUE if both conditions are met. |
| Assigns an alias to an element. This operator is optional, i.e., the assignment also works without the operator being written into the clause. |
| Is used together with ORDER BY and specifies that the search results are sorted in ascending order. |
| Identifies the average value of a set of numbers and is therefore valid for numerical values. |
| Enables a condition to be formulated for a table type on an object type. |
| Identifies the number of all entries of a column. Non-NULL-values are not counted. |
| The currentdate function gives you the current date. |
| The currentdatetime function gives you the current date and time. |
| The currentlongdate function gives you the current date in long format. |
| The currentlongdatetime function gives you the current date and time in long format. |
| The currentuserid function gives you the current user ID. |
| Makes it possible to add time spans to date expressions or subtract them. |
| Is used together with ORDER BY and specifies that the search results are sorted in descending order. |
| Removes all duplicates when identifying values. |
| Combines the result sets of two queries under the condition that the results appear in type 1 but not in type 2. |
| Checks whether a sub-query returns at least one record. |
| Logical truth value |
| Specifies the data source of the search statement. |
| Checks whether the specified value appears within a value list. |
| The itemid function gives you the item ID. For non-versioned types this is the sysId and for versioned types this is the item ID. All versions of an object instance have different sysIds, but always the same item ID. |
| Links an object to a relation type. |
| Identifies the length of a string including spaces. |
| Checks whether a string matches a particular pattern. On the right of the keyword LIKE there is a string that can contain the placeholder %. |
| Converts all letters of a string into lower case. |
| Removes spaces at the beginning of a string. |
| Identifies the highest value in a set. |
| Identifies the smallest value in a set. |
| Specifies that deriving object types are not searched in the query. |
| Negates the Boolean expression specified in the statement. |
| Use IS NULL or IS NOT NULL to check whether a field is empty or not empty. |
| Combines two conditions and returns TRUE if one of the conditions is met. |
| Results are sorted according to one or several field names. The default is sorting in ascending order (ASC). DESC must be entered if results are to be sorted in descending order. |
| Removes spaces at the end of a string. |
| Initiates a search statement. |
| You can cut out a part of a string using the substring function. The first int is the start position; the second int is the length. |
| Adds all elements of an object type and is therefore only valid for numerical values. |
| Removes spaces at the beginning and end of a string |
| Logical truth value |
| The typeid function returns the ID of the specified type. |
| Identifies the qualified name of the type for objects, relations, and all other types using the typeqname function. |
| Summarizes results of two queries without duplicates. |
| Converts all letters of a string to upper case. |
| Introduces a condition. |