Chat now with support
Chat with Support

Identity Manager 9.2 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using Windows PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

One Identity Manager query language

One Identity Manager has a language (One Identity Manager query language) 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_.]*

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating