Schweiz Deutschland Österreich
Schweiz Deutschland Österreich
AI Chat  
Schweiz Deutschland Österreich
vertec.com

List settings

How to configure lists in Vertec

Product line

Standard

|

Expert

Operating mode

CLOUD ABO

|

ON-PREMISES

Modules

Services & CRM

Budget & Phases

Purchases

Resource Planning

Business Intelligence

Created: 20.06.2003
Updated: 17.10.2024 | Added heading multiple sorting.

The menu button List settings, which is visible if you have the relevant user rights , opens the following window:

List view

Read-only

Controls whether entries can generally be entered and changed directly in the list (individual columns can still be locked with the column's read-only setting).
Show Add new row

Displays the asterix row that can be used to enter new entries in the list:

 

 

 

Columns

Title

The title later becomes the column heading.
It is an MLstring field, which means that the column titles can be entered in different languages.
Expression
 You can define here via an OCL expression what you want to show in the column. The expression can be typed manually or selected with the OCL expression editor .
Width
 Specify how wide the column should be shown. The column width can also be adjusted with the mouse in the list itself. Note: all users can change the column widths. But the change is only permanent if done by the administrator.
Totalized
 Here, you can specify whether the column should be totalized. This is useful for numeric values to show the total.
Alignment
 Alignment of the text in the column: left-aligned, right-aligned, centered
Fixed
 Starting with Vertec 6.4.0.8, columns can be fixed.
  • The fixed columns remain on the left when scrolling.
  • The fixed columns are identified by a separator line and stop when scrolling.
  • The first consecutive fixed columns are always considered. If a column, whose preceding columns are not all fixed, is configured as fixed, this setting is ignored.
Sorting

Here, you can define whether the list should be sorted by this column (this is the default setting when the list is shown again. Furthermore, if you define a sorting method, you can sort by each column by double-clicking on the column title).

Multiple sorting

Starting with Vertec 6.4, lists can be sorted by more than one column.

  • Sorting is done in the order of the column definitions, i.e. from left to right.
  • All columns involved in sorting are shown as sorted on the interface in the title:

If you click on a sorting arrow in the list, the list is sorted only according to the selected column. This modified search remains active until the list is shown again. Then the list is sorted according to the list setting.

If you no longer want to sort by a column, you have to explicitly set it to Unsorted.
Dynamic
 A column identified as dynamic is calculated in a list controller  and dynamically repeated. The exact operation is described in the section dynamic columns .
Tabstop
 Specifies whether to stop in this column when the tab key is used to navigate.
Read-only
 Controls whether or not this value can be edited directly in the list. For a value in the list to be editable, the read-only property of the list must be deactivated (see above).
Control XML
 Used to enter XML code for customizing the control elements.
Control name

In the control name field, you can save the name of a control. For example, the list settings screenshot above shows the cmbProjekt control for the project column of the service list. The result is that this control appears in the list:

You can find a list of all available controls here.
Renderer

A renderer renders Vertec data differently on the interface.

For example, the entered time spent on the service is saved internally in Vertec in minutes (minutenint). The renderer dbmTIM.MinuteRenderer causes these minute values to be displayed on the interface in line with the user’s settings (hour: minutes, hours.decimal, etc.).

You can find a list of all available renderers here.
Background color / font color

Choosing a different background or font color can be useful to highlight certain information. In the list settings, there are two ways to show colors:

  • As a constant color value: The color value is simply written into the relevant field. The entire column content, including title and total, is then displayed in this color:
  • As color expression: You can specify an OCL expression to calculate the color, e.g. if wertext < 500 then 'clRed’ else 'clBlack' endif. You can also write a single color value as a string in the corresponding field, e.g. 'clRed'. In this case, only the cell content is displayed in this color:

For a harmonious display, the colors in the new apps (Desktop App, Cloud App and Web App) only support the colors of the Vertec color palette, which consists of 15 colors in three gradations each, plus black and white.

The Vertec color palette

The supported color names are listed in the table below. The color palette has been expanded with Vertec version 6.6. For the colors supported before version 6.6, see here .

In addition to these colors, Vertec also supports the following Windows system colors:

clScrollBar, clBackground, clActiveCaption, clInactiveCaption, clMenu, clWindow, clWindowFrame, clMenuText, clWindowText, clCaptionText, clActiveBorder, clInactiveBorder, clAppWorkSpace, clHighlight, clHighlightText, clBtnFace, clBtnShadow, clGrayText, clBtnText, clInactiveCaptionText, clBtnHighlight, cl3DDkShadow, cl3DLight, clInfoText, clInfoBk, clWhite, clBlack.

Invisible font color

There is an additional supported color called clTransparent. This is only useful as a font color and makes the font invisible. It should only be used as a color expression, not as a constant color value. Otherwise, the entire column content, including the title and the total, are invisible.

Structure of OCL expressions for colors

Example of a color OCL expression on a list of invoices:

if bezahlt then 'clBlack’ else 'clRed’ endif

The OCL expressions must be constructed in such a way that the result is a string that is allowed as a color constant.
Remarks
 Starting with Vertec 6.4.0.4, a remark can be entered for each column.
Save as default
 With this button, you can set these list settings as the default for all lists of this class. This eliminates the tedious copying of list settings. A default defined in this way can be reset in the class settings of the relevant class.
Reset
 Resets the list to the default list settings.

You can change the order of the columns via drag & drop in the list:

  • Add column: With the + button, you add a new column. This is inserted as the next column after the currently selected column.
  • Delete column: The - button deletes the currently selected column.

OCL variables

Starting with Vertec 6.4.0.21, you can use OCL expressions in lists with  varContainer to access the container (folder or link container) and varParent to access the object to which the container belongs (parent object of the link container).

In addition to the column expressions in the list, the ListExpression and GhostRowListExpression of a control also have access to this context variable.

Note on licensing

It is not possible to use OCL expressions in column settings that refer to currently unlicensed Vertec modules. Such columns are automatically deleted again. If, for example, the Purchases module is not licensed and you enter auslagenmwst as an expression, the newly created column disappears immediately.

For Vertec versions before 6.6, the following color palette is available:

 

Bitte wählen Sie Ihren Standort