Skip to main content

Helpcenter

SwatGrid

With a SwatGrid, the data is displayed in tabular form and can be manipulated or searched for.

A SwatGrid can be used within screens in a container object, i. e., objects that include other objects, such as a panel in a SwatWindow or in a SwatFrame.

SwatGrid.png
  1. Panel menu: Default and individual functionalities.

  2. Filtering: Wildcards '*' are possible. F9 clears all filters within the grid.

  3. Records: By default, the first 50 records are displayed. Scrolling to the bottom of the grid loads the next 50 records.

All users are able to modify the column width and sequence. Changes are automatically saved per user logging out or by saving the profile in the profile menu.

  1. Open Design menu > Screens menu.

  2. Select the desired screen in the List of Screens.

    The Object Designer opens.

  3. Search for the desired SwatGrid in the Browse catalog of objects panel on the bottom right.

  4. Drag & drop the SwatGrid onto the Preview panel.

    Note

    Drop it to a position where the Preview panel is highlighted in green, not in red.

  5. Open the Flow view on the left side.

  6. Hover over icon center of the DSO until a fingertip appears and drag & drop the fingertip onto the SwatGrid icon.

    The Link Typ auswählen dialog opens.

  7. Choose the link type 'Data'.

  8. Click on Save.

You can set up a function to open a screen with the details of the selected record in a grid.

Open a Record via a link in a Detail Screen

The values within a column can be converted into a link. A click on this link opens the Detail Screen of the corresponding record.

  1. Open Design menu > Components menu > Grids.

  2. Select the desired SwatGrid in the List of repository objects panel.

    The Object Designer opens.

  3. Go to the Instances tab on the left.

  4. Select the instance to convert into a link.

  5. In the Attributes tab on the right, change the attributes as follows:

    1. VisualizationType: LINK

    2. SubType: LAUNCH

    3. updateRecordContainer: NameOfContainerObject (the name of the screen which should be used to show the details of the record)

Open a Record via a button in the Grid Panel Menu

Clicking on a button in the panel menu opens the selected record in a detail screen.

  1. Open Design menu > Screens menu.

  2. Select the desired screen containing the grid.

    The Object Designer opens.

  3. Select the SwatGrid.

  4. In the Attributes tab on the right, change the attributes as follows:

    1. panelMenu: gridPanelLaunchMaintenanceScreen#NoDropDown

    2. updateRecordContainer: NameOfContainerObject (the name of the screen which should be used to show the details of the record)

    3. BorderTitle: Must not be empty.

Note

The underlying panelMenu function is a default function for opening Detail Screens. For more details and properties of the panelMenu 'gridPanelLaunchMaintenanceScreen', open Design menu > Menus + Action menu and open a menu with the Menu Structure Code 'gridPanelLaunchMaintenanceScreen'.

The buttons which are displayed in the panel menu of the SwatGrid can be defined in the attribute panelMenu of the SwatGrid.

To add a save button:

  • Add gridPanelSaveOnly#NoDropDown to the comma separeted list.

  • Make the SwatGrid inline editable with the attribute enable = true.

  • Optional: Specify that only some columns are editable by disabling the columns that shouldn’t be editable in the grid. This can be done in the Instances view of the grid with the column attribute enable = false.

Attributes

Attribute

Description

Example/Values

ENABLED

Edit the data directly in the rows (inline editing).

true/false

instanceRestrictions

Defines the columns not to be displayed.

!fieldname1,!fieldname2,*

PanelMenu

List of all displayed buttons in the panel menu With gridPanelSave#NoDropDown a save and also delete button will be added to the panelMenu.

gridPanelLaunchMaintenanceScreen#NoDropDown,gridPanelSaveOnly#NoDropDown, gridPanelSave#NoDropDown

updateRecordContainter

Here you can specify the screen which is opened by clicking a link or the panelmenu.

BorderTitle

Defines the title displayed at the top left of the grid.

CanFilter

De-/Activate filtering per column.

CanSort

De-/Activate sorting per column.

usageBehaviour

Disable all links in a grid.

defaultsorting

Add a default sorting to a column in a grid.

Go to the connected DSO and fill the attribute with the name of the column you want to sort.