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}))?
In the One Identity Manager query language, query parameters are specified in SQL syntax.
@ParameterName
The parameter name matches the identifiers' definition.
Examples of valid parameter references
@Parameter
@Parameter1
@Parameter_1
@Parameter.SecondPart
Parameters can be compared using the following regular expression.
@[A-Z_][A-Z0-9_.]*
Related topics
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 [[].
Example of a preformatted Where clause
[isnull(lastname, '') = N'User']
Preformatted Where clauses can be compared using the following regular expression.
[([^]]|[]])*\]
Related topics
The One Identity Manager query language can be used to create queries or Where clause expressions against the One Identity Manager object layer.
The query language is not case sensitive. Keywords can be written in upper or lower case. To be able to identify them more easily, keywords are always written in capital letters in the following examples. In a lot of parts, the query syntax is based on SQL syntax.
Detailed information about this topic