Computed fields
Computed fields are fields in an entity whose values are automatically calculated in real time using SQL functions whenever the entity or its related data is updated.
Instead of manually entering values, the system computes them based on existing records, relationships, and business logic.
Supported types
- Decimal - e.g. total effort, revenue, balances
- Integer - e.g. counts, quantities
- Text - e.g. status labels, formatted results
Configuration
When creating a computed field, the following properties must be defined:
| Property | Description |
|---|---|
| FunctionName | Name of the SQL function that calculates the value |
| FunctionParameterDefinition | Parameters passed to the function, usually @EntityID int or similar |
| FunctionColumns | Columns of the entity the field is tied to, typically ID |
| BodyContent | SQL code that calculates and returns the computed value |
Computed fields are recalculated automatically whenever the underlying data changes.