Projection properties
Properties of properties:
-
The parameter “Order” contains the ordinal number of the column.
-
The parameter “Projection name” contains the name of the projection in the database to which the property belongs.
-
The parameter “Column name” contains the unique name of the column in the database.
-
The parameter “Title” indicates the column title displayed to the user.
-
The parameter “Type on display” changes the appearance of the output data (see Field values “Type on display”).
-
The parameter “Visibility” allows or prohibits the display of this column in the user’s table.
-
The parameter “Read-only mode” allows or prohibits editing of column data.
-
The parameter “Is nullable” allows or prohibits leaving the column value empty.
-
The parameter “Is foreign key” indicates whether the column is a foreign key. If the value is “true”, it has additional fields:
- The parameter “Reference entity” contains the name of the base entity. Immutable field.
- The parameter “Reference projection” contains the name of the projection of the base entity.
- The parameter “Reference key” contains the primary key of the base entity.
-
The parameter “Is virtual” contains a check box if the column is virtual:
- The parameter “Virtual property source” contains the name of the projection that is attached to the projection specified in the field “Projection name”.
- The parameter “Original column name” contains the name of the field containing data from the original projection. This data will be displayed in the created virtual columns.
-
The parameter “Show in reference” allows displaying the column value in drop-down lists.
-
The parameter “Concatenation” when displayed, combines this column with the previous one in accordance with the value of the field “Order”.
-
The parameter “Default value” contains the value that will be displayed if the column value is not filled in.
-
The parameter “Hint” when filling it out, displays a hint window when hovering over the column data.
-
The parameter “Pattern” contains a regular expression for checking the value entered in the field. Learn more in Checking with regular expressions.
-
The parameter “Additional parameters” contains (if necessary) parameters in JSON format that define additional processing for fields.