Multiple editing of list entries
It is possible to edit more than one object of the same object type at the same time in the List Editor.
- Use Shift + select or Ctrl + select to select the entries in the result list.
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
To display object relations
- Select View | Select table relations from the menu.
- You can specify which object relations are displayed in the List Editor.
Table 50: Items in the dialog box 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 51: 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 52: 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, the logged on user requires the program function Option to call the SQL editor in to run SQL statements in the SQL database (Designer_SQLEditor).
Detailed information about this topic
SQL Editor menu items
When the editor starts, the following menu items are available in the Designer.
Table 53: 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 |
Execute (F5) |
Executes the query. |
Show as table |
Switches output between text and table. |
Help |
SQL Editor help |
Opens the editor help. |
Table 54: 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. |
|
Executes the query. |