Skip to main content

Related entity multiline decimal

A table of lines from another table, maybe with a filter that relates them to this items DataID, and the option to input a decimal number next to each of them.

Properties

  • Type: Complex
  • Groupable: No
  • Show in lists: No
  • Searchable: No

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

This field requires configuration of both parameters before it shows.

Config1

The SQL-query executed, to list the items in the table.
The first column should be *DataID* of the subitem, but it doesn't have to be. As long as *a* column includes this data.
To relate the subtable to the current item, ad a *where clause* comparing to *[DataID]*, where *[DataID]* will be replaced be the current records DataID.

Config2

The Label of the input column in the table.

Developer info

  • FeltTypeID: 232
  • SQL datatype: INT(11)
  • Class name: FieldMultiInputSubformListSQL
Back to top