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+
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.
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}))?
In the One Identity Manager query language, query parameters are specified in SQL syntax.
@ParameterName
The parameter name matches the identifiers' definition.
@Parameter
@Parameter1
@Parameter_1
@Parameter.SecondPart
Parameters can be compared using the following regular expression.
@[A-Z_][A-Z0-9_.]*
As it is not possible to write all possible Where clauses due to the limitations of the One Identity Manager query language, you can incorporate preformatted Where clauses written in the SQL syntax of the underlying database system.
Preformatted where clauses are enclosed in square brackets ([ and ]). Opening square brackets in the clause can be masked with [[].
[isnull(lastname, '') = N'User']
Preformatted Where clauses can be compared using the following regular expression.
[([^]]|[]])*\]
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
