Paging clauses
Paging operators of the One Identity Manager query language make it possible to return only a subset of the selected entries.
Take clause
The Take clause specifies the maximum number of entries to be returned. If more than one Take clause is specified, only the last take clause is effective.
TAKE <integer>
Example
-- Return only the first ten persons from the result set
FROM Person SELECT DISPLAYS TAKE 10
Skip clause
The Skip clause specifies how many entries should be skipped from the beginning of the results before the entries are returned.
SKIP <integer>
Example
-- Skip 50 persons and return the following 15
FROM Person SELECT DISPLAYS SKIP 50 TAKE 15
Display value clauses
Display value clauses allow the definition of a user-defined display pattern. The table's display pattern and the display pattern (long) can be overwritten by a display value clause in the returned entries.
DISPLAY 'Display pattern'
LONGDISPLAY 'Display pattern'
The parameter in both cases is a string containing the display pattern with placeholders in the form %ColumnName%.
Example
FROM Person
SELECT DISPLAYS
DISPLAY '%Lastname%, %Firstname%'
LONGDISPLAY '%Lastname%, %Firstname% - %CentralAccount%'
Related topics
Query parameter clauses
In the One Identity Manager query language, query parameter clauses allow values to be passed in parameters that can be used in where clauses. You can pass a single parameter or a list of parameters.
Syntax for a single parameter
PARAM <Parameter name> [ OF <Type> ] = <Value>
Syntax for multiple parameters
PARAMS
<Param1> [ OF <Type> ] = <Value>,
<Param1> [ OF <Type> ] = <Value>,
Permitted parameter names are:
Valid types are the .Net data types of the object layer defined in ValType enumeration. If the type can be derived from the value, you do not have to give a type.
Examples of query parameters
PARAM Parameter1 = 'Harris'
PARAM @Parameter2 = 'Harris'
PARAM Parameter3 OF String = 'Harris'
PARAM @Parameter4 OF String = 'Harris'
PARAM Parameter5 = 42
PARAM Parameter6 OF Int = 42
PARAMS
Parameter7 OF Double = 3.14,
Parameter8 OF Date = 2020-04-30
Example: Complete query with parameter reference and definition
FROM Person
WHERE LastName = @Param1
SELECT DISPLAYS
PARAM Param1 = 'Harris'
Related topics
Query hints
Query hints (keyword HINT) can be used in the One Identity Manager query language to provide the query processor with additional data. Query hints are used internally to provide a context for additional permission queries to display columns that are only available when loaded as display values for foreign keys of another table.
HINT 'Name' = 'Value'
Example: loading a Person object referenced by a Department object as UID_PersonHead
FROM Person
WHERE PRIMARYKEY '<Key><T>Person</T><P>99918ef1-113f-480a-8e6e-704b1a3cf73a</P></Key>'
SELECT DISPLAYS
HINT 'SourceContext' = 'Org'
