In the One Identity Manager query language, identifiers always start with an ASCII character in the range A to Z or with an underscore (_). Digits are valid only after the first position. Identifiers can contain several parts delimited by dots (.).
Examples of valid identifiers
Name
Name1
_Name
Name_1
Alias.Name
Identifiers can be compared using the following regular expression.
[A-Z_][A-Z0-9_.]*
Literals define values of certain data types in the query. The following literal values are supported in the One Identity Manager query language.
Detailed information about this topic
In the One Identity Manager query language, strings are enclosed in single quotes. Single quotes within strings are masked by doubling the single quote. All string contents are Unicode. The N character at the beginning of the string is allowed to ensure some compatibility with SQL syntax. It has no special meaning.
Examples of valid strings
''
N''
'A string'
'A ''string'''
N'A string'
Strings can be compared using the following regular expression.
N?'([^']|'')*'
A special case of strings are multi-valued properties. These are strings delimited by ASCII 7 characters. Multi-valued properties can be expressed in the query syntax in this form:
MVP('Value 1', 'Value 2', 'Value 3')
The resulting value can be used in most places where strings are valid.
In the One Identity Manager query language, integer values contain digits and an optional plus sign (+) or minus sign (-).
Examples of permitted values
42
+42
-42
Integer values can be compared using the following regular expression.
[+-]?\d+