Expression folder
To work with Expression Folders
Product line
Standard
|Expert
Operating mode
Cloud Suite
|ON-PREMISES
Modules
Services & CRM
Budget & Phases
Purchases
Resource Planning
Business Intelligence
Created: 20.06.2003
Machine translated
Updated: 20.02.2025
|
Checkbox “Expandable” from version 6.7.0.17.
An expression folder calculates the contents of the folder based on an Ocl expression. This allows you to create filter folders that always show only the entries that match the criteria. An example of an expression folder would be to show all users who have worked overtime, the distribution of addresses by state, etc.
Right-click on the folder where you want to create the expression folder and click on Neu > Expression-Ordner. The Properties window will appear in which you can specify:
designation |
Under this name, the folder is displayed in the tree. |
Expression |
Here you can enter an Ocl expression. You can either type it manually or compile it using the Ocl expression editor. |
'New’ Class |
If you want to create new objects in this folder, you can specify the type of these objects here. |
list controller |
A List Controller can be stored here. |
Index |
The index can be used to specify the sort in the tree. Vertec simply sorts the folders by ascending index. If nothing is specified, the folders are sorted alphabetically. |
Icon |
All icons in Vertec are assigned a number. If you want to use a different icon for this folder than the default folder Icon (-1), you can enter the index of the desired icon here. The corresponding numbers can be found in the article Icons. An expression folder can be recognized at a glance by the fact that it has a gear in the standard icon. |
Own list for each type |
If the folder contains entries of different types, a separate list can be shown for each type. See the article Folder contents with separate list per type. |
Expandable |
Vertec 6.7.0.17. If this checkbox is deactivated, the folder in the tree cannot be opened. |
Defining queries
As of Vertec 6.2, queries can be defined for expression folders and the entered parameters can be used in the folder expression as well as in the column expressions.
No queries have to be defined for the expression folder to work, it is also sufficient to specify only one expression. However, if you want to be able to pass certain search parameters, which are queried by the user, queries can be defined.
The button Abfragen definieren… opens the dialog for creating the queries.
The field names are applied as variable names, like the SQL folders, preceded by var. When forming the variable name based on the field name, only letters and numbers from the ASCII range are taken into account. All other symbols (e.g. spaces, hyphens, umlauts etc.) are filtered out and not taken into account for the variable name.
In the example above, there is a variable varteamleiterkrzel from this field, which can be used in the OCL expression as well as in the column expressions of the list settings:
projektbearbeiter->select(teamleiter.kuerzel=varteamleiterkrzel)
The OCL Expression Editor knows these variable names and displays the expression as valid.
As with the SQL folder, several search fields can be defined. These are created with the + in the query dialog.
Individual query fields can be removed with the – button.
As soon as you click on OK in the query dialog, the query is created and the corresponding field is shown on the interface:
The folder search can also be executed directly by activating the Sofort Suche in the query dialog. This allows the search to be executed directly when the folder is displayed with the default search parameters (e.g. the logged-in user) without having to click on Suchen.
Further searches can be made as usual by changing the search parameters and using the search button.
The entire query is deleted by clicking on the Alle entfernen button in the query dialog, and the expression folder behaves like an “ordinary” expression folder again.
For expression folders with query, a class name is additionally shown in the properties dialog:
For expression folders without a query, this field is hidden because it is not needed because the class results from the expression itself.
The contents of an expression folder are calculated at the time of display, so the displayed data is always the current state. For large amounts of data, it may take some time to display such an expansion folder.