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.
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.
FROM Table WHERE PRIMARYKEY '<Key><T>Table</T><P>UID</P></Key>'
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.
Where-clauses in the One Identity Manager query language start with the WHERE keyword and contain a condition that the resulting data must match. Unlike SQL syntax, multiple Where clauses can be combined in a One Identity Manager query language query.
WHERE Lastname = 'User1'
WHERE Lastname = 'User1' AND Firstname = 'Chris'
WHERE [isnull(lastname, '') = N'User1]
WHERE Lastname IN ('User1', 'User2')
WHERE XDateInserted IN RANGE LAST MONTH
In the One Identity Manager query language the SEARCH keyword is used to search for all matching entries from the full text index. To use this type of clause, a full text index must be installed and accessible from the application.
SEARCH 'Search string'
© 2024 One Identity LLC. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
