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.
For example, the One Identity Manager query language is used to communicate between application servers and clients. Currently, you can use the One Identity Manager query language in the Object Browser's query window .
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. This makes it easier to convert simple Where clauses from SQL syntax to the query syntax.
Detailed information about this topic
Language elements of the One Identity Manager query language
The One Identity Manager query language supports different language elements.
Detailed information about this topic
Comments
There are two types of comments in the One Identity Manager query language. These are analog to comments in SQL syntax:
Line comments
Line comments start with -- and end at the end of the line.
-- This is a line comment
Line comments do not have to be at the beginning of the line.
FROM Person -- This is a line comment too
Block comments
Block comments start with the /* and end with */. Block comments can span more than one line.
/* This is a block comment
that spreads over
more than one line */
Identifier
In the One Identity Manager query language, identifiers always start with an ASCII character in the range A to Z or with an underscore (_). Digits are valid only after the first position. Identifiers can contain several parts delimited by dots (.).
Examples of valid identifiers
Name
Name1
_Name
Name_1
Alias.Name
Identifiers can be compared using the following regular expression.
[A-Z_][A-Z0-9_.]*