DBRecordFieldMapping
This page provides generated reference documentation for the DBRecordFieldMapping data model.
A field for a DB record container
Overview
| Property | Summary |
|---|---|
| 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. |
| 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… |
| columnAlias | SQL alias used for recordfield / expression in the generated select statement (e.g. "recordfield AS columnAlias"). |
| 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
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.
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.
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).
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.