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 |
Typically functions require some values to be passed as parameters.