system
(system)
December 31, 2017, 11:00pm
1
Functions define a set of functions you can use for modeling data filters or simple calculated entity fields . You can add your own database functions (that you create manually in the database and map using this part of the model).
Types
You can use standard functions on the entity level to define
Calculated fields
Entity filters
Calculated fields will not be stored in a data store but their values are calculated by the system. The values will be recalculated by the front-end when changed by the user.
These functions are built-in and you cannot define your own functions.
If you need special calculations to take place or if you want to persist the calculated values you need to use Data Structure Rule Sets .
If you need speci…
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…