GBS AppDesigner: Integrating 3rd party applications
GBS AppDesigner is a flexibly deployable Web 2.0 development framework.
Its central task is the facilitation of developing web-enabled, modern, and process-supported business applications. It also allows for the addition of a state-of-the-art web UI to existing IBM Notes applications. Simple applications, such as access authorizations, pin boards, or FAQs can be created in only one hour.
Oftentimes, however, information from other applications or centrally maintained guidelines, for example the authorization of materials, is to be integrated into the form.
The following example shows how information of this type can be integrated using the “dynamic dropdown” field.
The form entitled “Material Order” (Image 2) contains three fields of the ‘dynamic data dropdown’ type. Their task is to read values from a configuration database and to show the available cellphones and office printers, as well as the total entries of the third field.
Any desired parameter lists can be created in the GBS settings database using several documents. Each document (parameter list) is assigned a clear name (e.g. “CellPhones“) and a simple text list containing one parameter per entry (e.g. “Samsung SIII”).
These parameters are centrally managed by an administrator and selected by the user when the document is created.
Form with three "Dynamic Data Dropdown" fields
Each field is now connected with another data source. For this process, the design element details are opened, instead of the validation settings containing the default formulas:
Now all @Formulas for XPages can be applied as formulas.
The following formula opens a database named sdir_app.nsf in the AppDesigner/Demo directory of the current server (the first array entry of @DBName()), which can be found under the data directory of the following server:
@DbLookup([@DbName(),"AppDesigner/Demo/sdir_app.nsf"], ".HiddenLists", "OfficePrinter",2 )
It retrieves all values from the second columns of the “HiddenLists” view available for the document “OfficePrinter” (content of the first column).
The general formula
@DbLookup([@DbName(),pavGlobalSettingBean.getConfigPathByDBKey("RepDB")],".HiddenLists", "CellPhones", 2 )
It employs a GBS PAVONE API method, in order to retrieve the configuration of the paths created in the configuration of the GBS AppDesigner application for a settings database. Using the parameters “RoutDB” (Process Directory), “OrgaDB” (Organisation Directory) and “NABook” (IBM N&A), additional pre-configured databases can be accessed.
The “Dynamic Data Dropdown” field may look similar to the one below:
If there are no entries, simply enter “none” or the “|“-symbol into the parameter field. The advantage of the “|“-symbol is that nothing will be displayed at all.
@Unique(@DbColumn([@DbName(), "AppDesigner/Demo/sdir_app.nsf"], ".HiddenLists", 2) )
Retrieves all entries from the second column of the“.HiddenLists” view and also ensures that no entry appears twice in the displayed list thanks to @Unique!