Defining insert values
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 accesses the object that is currently loaded. Insert values are described with the following syntax:
-
Value assignment with variable replacement (value must be a character string)
Base.PutValue("<column>", context.Replace(<value>))
All the columns of the table to be displayed may be applied. You can use variable for defining insert values.
Example:
Base.PutValue("IsITShopOnly", 1)
Base.PutValue("UID_ADSContainer", context.Replace("%cont%"))
NOTE: If you changed insert values, you must recompile the database.
Related topics
Using links in the navigation
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 links themselves do not appear in the navigation. Instead the referenced menu items and their child menu items are shown.
Figure 13: Structure of the navigation interface using links in the User Interface Editor (left) and display in the Manager (right).
Special features of using links
-
Links inherit some properties of the reference entry.
-
You can use variables in the reference entry, for example in conditions for lists or data-dependent menu entries. Value assignment to the variables only takes place in the link. You must define the variables in the link.
-
The caption and the icon of the reference entry are overwritten with the corresponding values from the link.
To use links
-
Create the menu item that you want to use as the reference entry.
-
If necessary, create other menu items below the reference entry.
-
Create the menu items that link to the reference entry. Enter at least the following information for the link.
-
Menu item: Enter the name of the menu item.
-
Entry type: Select the Link entry type.
-
Menu item link: Select the reference entry to be shown at runtime when the link is called.
-
Assign an application and the permissions groups.
-
Select the Database > Commit to database and click Save.
TIP:
-
If the menu item is of the Link type, you can use the Follow link node context menu to navigate to the reference entry.
-
For a reference entry, you can use the Referenced by context menu to display all links that refer to this reference entry and then navigate to these entries.
Related topics
Using variables in the navigation
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 14: Inheriting variables in a hierarchical navigation interface
The variables of the session object that are listed below are always available when the menu items are being set up.
Table 38: Global session object variables
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 displayed in XUserInserted or XUserUpdated. |
UserUID |
Logged in user’s UID_Person, if user related authentication is being used. |
ShowCommonData |
Specifies whether system data is shown (1) or not shown (0) The variable is evaluated in the Designer by the program settings. |
SessionType |
Specifies whether a direct database connection or a connection over an application server is supported.
Direct database connection only: '%SessionType%' = 'Direct'
Connect with the application server only: '%SessionType%' = 'AppServer' |
In addition to the variables belonging to the session object, you can also define other 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.
Table 39: Permitted variable definitions
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 Multilingual and List of permitted values column properties are resolved when creating the display value for a column. |
Text |
Any string |
Freely defined value |
Can be used in all menu items.
NOTE: Format values that can potentially contain apostrophes (') using the DBString formatting function.
Example:
Variable: PersonWhereClause
Value: LastName = '%Name:DBString%' |
Use the following syntax when you edit the navigation to access the variables:
%Variable%
Related topics
Creating and displaying variables
In the Designer, you can use the User Interface Editor to create variables for the navigation menu. The Define variables view, has a toolbar that provides various editing features.
|
Creates a new variable. |
|
Deletes the selected variable. |
|
Opens the extended edit dialog.
Tip: For variables of the Text variable type, automatic completion of formatting is available in the extended edit dialog. To use this, enter a colon (:) in the Value or source column input field in the extended edit dialog. |
|
Displays variables inherited from parent menu items. |
To create variables
-
In the Designer, select User interface > User interface navigation category.
The menu items are loaded and displayed in the User Interface Editor for editing.
-
Select the menu item in the navigation overview.
-
In the edit view, select Variable definitions.
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.
-
To create a variable, click and enter the following information.
-
Type of variable: Select Column, Display value, or Text.
-
Variable: Enter the name of the variable.
-
Value: Enter the value of the variable. The value to be entered depends on the variable type.
-
Select the Database > Commit to database and click Save.
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
-
In the Manager, enable the Show additional navigation information program setting.
-
In the Manager, select menu item in the navigation and select the Definition > Defined variables context menu item.
Related topics