Parameter references
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
Preformatted Where clauses
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'Harris']
Preformatted Where clauses can be compared using the following regular expression.
[([^]]|[]])*\]
Related topics
Formulating queries in the One Identity Manager query language
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
Query header
Data queries in the One Identity Manager query language always start with the FROM keyword and a table name. An optional alias for the table can be specified after the AS keyword.
FROM <table name>
FROM <table name> AS <table alias>
An alternative is to query directly using an object key.
Example of the query in long form
FROM Table WHERE PRIMARYKEY '<Key><T>Table</T><P>UID</P></Key>'
Example of the query in short form
FROM '<Key><T>Table</T><P>UID</P></Key>'
You can specify a list of clauses after the query header. The clause types do not have to be in any particular order.