Field Types

[system]

The following field types can be created in the entity model:

1150×1150 16.3 KB

This field type allows you to create a calculated total field using an aggregate function. Attributes Relation Specifies a relation to an entity that contains the fields you want to …

1150×1150 16.3 KB

This model element maps an entity field to a physical, such as a database or a column. Attributes MappedColumnName Name of the physical field, e.g. database field. When creating a…

1150×1150 16.3 KB

This type of field allows you to look up a value from another entity based on a field in the current entity using a lookup. Attributes ExcludeFromAllFields If set to True, the fie…

1150×1150 16.3 KB

This field type is not mapped to any physical database field. Attributes. Virtual fields have no extra attributes. Example You need to create a checkbox field for the user in order to sele…

Database Field	Maps an entity field to a physical, e.g. a database or a column.
Virtual Field	Provides a basic field type not mapped to a database. Can be used for in-memory operations.
Function Call	Calculates a value by calling a basic or a database function.
Aggregated Field	Calculates a total value from child entities using an aggregate function.
Lookup Field	Looks-up a value from another entity based on a field in the current entity using a lookup.