Multiple editing of list entries in the List Editor
It is possible to edit more than one object of the same object type at the same time in the List Editor.
Entries in the list that have different input are specially labeled in the edit view. The values entered and saved in the fields are stored for all objects.
Displaying object relations in the List Editor
To display object relations
-
Select the View > Select table relations menu item.
-
You can specify which object relations are displayed in the List Editor.
Table 51: Entries in the dialog's context menu
Show relation |
The editing window for the object relationship is displayed in the editing view of the editor. |
Hide relation |
The editing window for the object relationship is hidden in the editing view of the editor. |
- Click OK.
Each relation is shown in its own edit window. To change the assignments, double-click the icon or choose the required option from the context menu.
Table 52: Meaning of icons in the view
|
Object is assigned to the selected base object. |
|
Object is not assigned to all selected base objects (multiple entry editing). |
|
Object is not assigned to an object. |
Table 53: Items in the view’s context menu
Assign |
Assign object to the selected base object. |
Remove |
Remove assignment of object to base object. |
Properties |
Displays the object properties of the selected entry. |
Navigation |
Shows all other editors that can be used with the selected object. |
Working with the SQL Editor
You can use the SQL Editor to run database queries against the internal Designer’s SQLite database. This internal database contains the schema and the files from the system components of the connected One Identity Manager database.
NOTE: To use the SQL Editor in the Designer, users require the Designer_SQLEditor program function.
Detailed information about this topic
SQL Editor menu items
When the editor starts, the following menu items are available in the Designer.
Table 54: Menu items added by the editor
Edit |
Undo |
Restores state before last change. |
Redo |
Restores state after last change. |
Cut |
Deletes marked code but save in clipboard. |
Copy |
Copies selected code to the clipboard. |
Paste |
Inserts data stored in the clipboard from copy or cut. |
Delete |
Deletes selected code. |
Reduce text indent |
Reduces the indent of the selected code in the query window. |
Increase text indent |
Increases the indent of the selected code in the query window. |
SQL |
Run (F5) |
Runs the query. |
Show as table |
Switches output between text and table. |
Help |
SQL Editor help |
Opens the editor help. |
Table 55: Meaning of toolbar icons
|
Undoes last change. |
|
Redoes last change. |
|
Cuts selected code. |
|
Copies selected code into clipboard. |
|
Inserts code from clipboard. |
|
Deletes selected code. |
|
Reduces the indent of the selected code in the query window. |
|
Increases the indent of the selected code in the query window. |
|
Switches output between text and table. |
|
Runs the query. |