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
- For example, mark a node of type Container, and, in the context menu, select the Wizards > Create data display item.
- In the Display wizard dialog, select the Create a grid display for collection data option and click OK.
This displays Collection. You can apply the following settings.
Table 53: Collection settings
| 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  to open the wizard for setting filter conditions. |
- On the Collection page, configure the settings and click Next.
- On the Columns page, select the database columns for which you want to display detailed information and click Next.
- Configure the following details on the Layout page and enter a name for the layer.
Table 54: Layout settings
| 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. |
- Click Finish.
This data completes the definition of the first grid layer. Another window opens. This window displays the grid layers that are already defined.
- Perform one of the following tasks:
- Add another grid using
.
- Mark the existing grid and edit it using
.
- Mark the existing grid and delete it using
.
- Confirm the Create a new grid - layers pane with Ok.
The Web Portal is has been designed not only for use with desktops but also mobile devices, so you can modify the mobile view settings. You have different setting options in the Web Designer.
Detailed information about this topic
The Web Designer offers different setting options for adjusting the usual desktop grid view in the Web Portal to suit a mobile mode. The List view node is available at every grid level. This means, you can make changes in the Web Designer anywhere where these nodes are available.
The following table describes the setting options for the list view.
Table 55: Display options for the list view
|
Disable list view |
The grid view is used as apposed to the list view in mobile mode in the Web Portal. This setting is not recommended because it makes operating and displaying difficult due to lack of space on mobile displays. |
|
Automatically generate the list view |
This setting automatically generates the list view for mobile mode. This is sufficient for simple tables, meaning, a list view without other options and buttons. |
|
Define a list view |
This setting allows you to customize the list view. The list view works independently of the table view for this setting, meaning, if changes have been made to the table view, you must also make them in the list view, otherwise, the changes are not visible in the list view. |
NOTE: The groups and filter function is not available in mobile mode. You can 'leaf' backward and forward within the list view.
Customizing the list view is described using an example based on the component VI_ITShop_ApprovalItem, which is used in the Pending requests menu in the Web Portal.
To customize the list view
- Open the component VI_ITShop_ApprovalItem in the definition tree view.
- Create an object copy and ensure that Add substitution rule for current object is not set.
- Open Grid band - PersonWantsOrgGrid under Definitionin your object copy.
- Mark List view and select the entry you want from the List view mode menu in the Node Editor view. The following items are available:
- Disable list view
- Automatically generate the list view
- Define a list view
You can disable list views in mobile mode in the Web Portal with the help of the configuration parameter VI_Common_GridListViewDisabled.
To disable list views
- Open Edit > Configure project > Web project and search for VI_Common_GridListViewDisabled.
The configuration is displayed with the default setting 'false'.
- In the Value (custom), click
.
This sets the configuration parameter to "true". Enable "Disable all grid list views".
