Database Functions

[system]

Fields and filters called by a Function Call Field that are defined with database functions will be retrieved from the database but will not be recalculated, for example if the user changes data in a screen. The fields will be recalculated after changes are saved to the database.

Custom Defined Database Functions

There are some predefined functions delivered with the root package but you also can define your own database functions by right-clicking on the Functions, selecting New > Function and providing the following attributes.

The function needs to exist in the database already and has to have the same name as in the model. Don’t forget to provide a Deployment Script for your function so it will be successfully deployed to the target database.

You can let Architect create a boilerplate code for your function. Just model the function including the parameters, click on the function and look at the Output window. It will show an SQL to create the function.

Name	Name of the function exactly as named in the database.
DataType	Data type of the return value.
FunctionType	Always use Database

Child Elements

1150×1150 16.3 KB

Typically functions require some values to be passed as parameters. To define a parameter, add a Function Parameter element under the function with the following attributes: Name Name the function parameter exactly as it is named in the database. OrdinalPosition In case the database provider does not allow the parameters to be referenced by name, use this field to indicate the position of the parameter in the function header.