You can use insert values to initialize individual values when a new data set is added over the result list. You can apply insert values to interface forms, object definitions, menu item lists and tables.
Enter insert values in VB.Net syntax. The Base. syntax always addresses the object that is currently loaded. Insert values are described with the following syntax:
All the columns of the table to be displayed may be applied. You can use variable for defining insert values.
NOTE: If you changed insert values, you must recompile the database.
Links support the navigation configuration. Links are implemented to reference frequently used menu items. Parts of the navigation interface that require an application several times, only need to be set up once. The referenced menu items are always shown in navigation interface as opposed to the links.
For more information about general properties of menu items, see General Menu Item Properties.
You specify which menu item is shown at run-time with the property Menu item link. Certain link properties are passed on to the menu item. The display text and the icon for the referenced menu item are overwritten by the appropriate values. Even so, the variable definitions are passed on from the link to the referenced menu item.
Figure 29: Structure of the Navigation Interface using Links in the User Interface Editor (left) and How it Appears in the Manager (right).
You may use variables to configure identifiers and menu item display templates for menu items in insert values and database queries. In some parts of the navigation interface you have to implement variables as, for example, in the case of formulating database queries for recursive data dependent menu items.
Variables are inherited within a hierarchical navigation. This means that variables in deeper levels of a hierarchy can be reused or overwritten. The actual run-time value is passed to the variable.
Figure 30: Inheriting Variables in a Hierarchical Navigation Interface
The session object variables described in the following, are always available when menu items are being set up.
|EnvUserName||Name of user to be authenticated in the environment, for example, "Domain\User" in Active Directory.|
|LogonUser||DialogUser.Username of the currently logged in user.|
|DialogUserUID||DialogUser.UID_DialogUser of the logged in user.|
|UserName||Name to be displayed in XUserInserted or XUserUpdated.|
|UserUID||Logged in user’s UID_Person, if user related authentication is being used.|
Specifies whether system data is shown (1) or not shown (0). The variable is evaluated in the Designer by the program settings.
Specifies whether a direct database connection or a connection over an application server is supported.
Only direct database connection: '%SessionType%' = 'Direct'
Only connection through application server: '%SessionType%' = 'AppServer'
You can also define variables. The variable definition is made up of variable type, variable name and the value. Basically, any string is permitted in the variable definition. However, events have proved that it is a good idea to use a pattern that is unlikely to occur in the data but is accepted as a string by the database server in use.
|Variable Type||Variable name||Value||Usage|
|Column||Any string||Current object’s column name||Only used in data dependent menu items.|
|Display value||Any string||Current object’s column name||Only used in data dependent menu items. The column properties multilingual and List of permitted values are resolved when creating the display value for a column.|
|Text||Any string||Freely defined value||Can be used in all menu items.|
Use the following syntax to access the variables:
To edit variables
In this view, all the variable definitions that belong to the selected menu item are displayed in tabular form with type, name and assigned value.
TIP: To show variables inherited from parent menu items, click .
TIP: A list of available types is shown by clicking on the variable type in the table grid. The variable name and the value can be edited by clicking on the appropriate column in the table.
The actual value stored in the variable can be shown in the administration tools as additional navigation information.
To display variable values of a menu item in the Manager