Difference between revisions of "FieldMultiInputSubformListSQL"
Jump to navigation
Jump to search
old>Tvi (Created the page) |
m (1 revision imported) |
(No difference)
| |
Latest revision as of 11:52, 10 December 2021
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
Configuration
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.