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.