立即与支持人员聊天
与支持团队交流

Identity Manager 8.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 SOAP Web Service One Identity Manager as SPML provisioning service provider Processing DBQueue tasks One Identity Manager Service configuration files

String values

In the One Identity Manager query language, strings are enclosed in single quotes. Single quotes within strings are masked by doubling the single quote. All string contents are Unicode. The N character at the beginning of the string is allowed to ensure some compatibility with SQL syntax. It has no special meaning.

Examples of valid strings

''

N''

'A string'

'A ''string'''

N'A string'

Strings can be compared using the following regular expression.

N?'([^']|'')*'

A special case of strings are multi-valued properties. These are strings delimited by ASCII 7 characters. Multi-valued properties can be expressed in the query syntax in this form:

MVP('Value 1', 'Value 2', 'Value 3')

The resulting value can be used in most places where strings are valid.

Integer values

In the One Identity Manager query language, integer values contain digits and an optional plus sign (+) or minus sign (-).

Examples of permitted values

42

+42

-42

Integer values can be compared using the following regular expression.

[+-]?\d+

Decimal values

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 (.).

Examples of permitted values

3.14

+3.14

-3.14

Decimal values can be compared using the following regular expression.

[+-]?\d*\.\d+

Date and time values

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}))?

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级