String values
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.
Integer values
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+
Decimal values
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 (.).
Examples of permitted values
3.14
+3.14
-3.14
Decimal values can be compared using the following regular expression.
[+-]?\d*\.\d+
Date and time values
In the One Identity Manager query language, date and time values are specified in ISO notation. The time part is optional. If a time is given, seconds and the milliseconds are also optional.
By default, the time values are specified in the UTC time zone. Alternatively, a time zone can be specified with the TIMEZONE keyword and a string containing the time zone's name. In date ranges, the TIMEZONE name comes at the end of the format value and applies to both date and time.
Examples of permitted values
2020-04-01
2020-4-1
2020-04-01 12:30
2020-04-01 12:30:24
2020-04-01 12:30:24.523
2020-04-01 12:30:24 TIMEZONE 'W. Europe Standard Time'
Date values can be compared using the following regular expression.
d{4}-\d{1,2}-\d{1,2} \d{1,2}:\d{1,2}(:\d{1,2}(.\d{1,3}))?
