Literals define values of certain data types in the query. The following literal values are supported in the One Identity Manager query language.
Literals define values of certain data types in the query. The following literal values are supported in the One Identity Manager query language.
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.
''
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 (-).
42
+42
-42
Integer values can be compared using the following regular expression.
[+-]?\d+
In the One Identity Manager query language, decimal values contain digits and an optional plus sign (+) or minus sign (-). The decimal part is separated by a dot (.).
3.14
+3.14
-3.14
Decimal values can be compared using the following regular expression.
[+-]?\d*\.\d+
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center