AggregateFieldDBMapping
This page provides generated reference documentation for the AggregateFieldDBMapping data model.
An aggregate field in a database record container
Overview
| Property | Summary |
|---|---|
| aggregateType | The aggregate type of the field |
| columnAlias | SQL alias used for recordfield / expression in the generated select statement (e.g. recordfield AS columnAlias). |
| expression | Process that returns an SQL expression that will be used in the generated select statement (instead of the record field). Often this is a subselect or a… |
| isFilterable | Specifies, whether a field or filterextension is filterable. Filterable fields will be available for selection by a user. |
| isLookupFilter | For a column of the lookup component, specifies whether to search for data in it. That is, if a term is entered in the lookup component, it searches for… |
| recordfield | Database column that provides the values of the corresponding EntityField. The value of this property will be included in the generated SQL select statement. |
aggregateType
Type: EAggregateType
The aggregate type of the field
columnAlias
Type: String
SQL alias used for recordfield / expression in the generated select statement (e.g. recordfield AS columnAlias).
In particular, with this property you are able to simplify references to complex expression subselects in other parts of the generated SQL code (e.g., in an orderClauseProcess).
expression
Type: String
Process that returns an SQL expression that will be used in the generated select statement (instead of the record field). Often this is a subselect or a case-when statement. You do not need to specify surrounding brackets - this is done automatically.
If both properties recordfield and expression are set, only expression will be executed.
If you want to refer to this expression in other parts of the SQL code (e.g., in an orderClauseProcess), you should set and use property columnAlias.
isFilterable
Type: Boolean
Specifies, whether a field or filterextension is filterable. Filterable fields will be available for selection by a user.
isLookupFilter
Type: Boolean
For a column of the lookup component, specifies whether to search for data in it.
That is, if a term is entered in the lookup component, it searches for matches in all columns marked as isFilterable.
recordfield
Type: String
Database column that provides the values of the corresponding EntityField. The value of this property will be included in the generated SQL select statement.
If both properties recordfield and expression are set, only expression will be executed.