To add a new node
The selected database object is displayed in its own tab in the definition tree view.
|
Note: The procedure for adding new nodes differs somewhat if the database objects are standard objects or custom objects. In the case of standard objects, you must first move the node to the extension using the context menu before you add a new node. You have additional write permissions for custom objects and you can add a node directly under the node in the definition tree view. |
|
NOTE: You will see different submenu structures in the context menu depending on which database object or which node types you have selected. |
The new node is displayed in the definition tree view.
The core task of a web application created with Web Designer is targeted visualization and manipulation of database objects.
|
NOTE: The wizard is only available for node types to which corresponding displays can be added. |
You can create the following data display types with the wizard.
This results in a list of single database objects and allows you to change (overwrite) selected properties.
The resulting table shows all properties of database objects. Relations between single database objects can be displayed in hierarchical form.
Use this wizard to include an edit mask into your web project. You can edit several properties of individual data set as a bundle. Use filters to limit how many objects are displayed. Data objects are not mapped in tables but in sections. Each individual data object from the selected or new collection is displayed in such a section (iteration). Therefore, each individual data object produces a data set and is displayed in a list.
To view the object details
|
NOTE: You must have already selected a database object. If you have selected an object, which belongs to the default version, you will find the wizard in the context menu under Element in extension. |
This opens the Source selection page. You can apply the following settings.
Option | Setting | Description |
---|---|---|
Use existing collection | Selection box with a list of available collections. | |
Filter on | Input field for filter conditions. | |
Create a new collection | Adds a new collection. | |
Use display names | Enables/Disables displaying of database names. | |
Base table | Database table selection. | |
Collection name |
Input field for the collection name. The data object to be displayed are saved in this collection. | |
WHERE clause |
SQL input box for setting filter conditions. Use |
|
NOTE: The WHERE clause can also contain an internal variable as in the rest of Web Designer (keyword "Web SQL"). In this case the SQL syntax editor cannot be used. The WHERE clause can still be added or edited after the wizard is closed. |
|
NOTE: If the option Read-only is disabled, the property in the web application can only be edited with special permissions. You need to add another button once the wizard is complete, so that the changes can be saved in the database. The displayed columns are written as value list directly under the function node PropertyList(). |
|
Note: The list of editors is displayed on the web page under each other. To view individual data sets, you must change the container style in the definition tree view, which encloses the component VI_Common_PropertyEditor. |
This part of the wizard creates a grid view for data from one or more collections.
You can assign data object hierarchically in the process. This means that data objects which are defined as dependent (foreign key relation) on another database object stored in the same or another collection can be displayed in another layer.
To create a grid display for collection data
This displays the Collection page. You can apply the following settings.
Option | Setting | Description |
---|---|---|
Use foreign key relation | Selection box with a list of available foreign key relations. | |
Use existing collection | Selection box with a list of available collections. | |
Create a new collection | Adds a new collection. | |
Base table | Database table selection. | |
Collection name | Input field for a collection name. | |
WHERE clause |
SQL input box for setting filter conditions. Use |
Setting | Description |
---|---|
Layer name (Identifier) |
Gives the layer a name. The layer caption is only used help the search for properties that you may want to change later. |
Display title | Enables/Disables the title display. |
Enable the user to sort columns | Allows the user to sort data objects in their own way. Grid contents can be resorted by clicking the column title bar. |
Sort collection |
Sorts the collection according to a set criterion. The criterion is set using both selection boxes. |
This data completes the definition of the first grid layer. Another window opens. This window displays the grid layers that are already defined.
© 2023 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy