Selection TreeView
2 minute read
If only one value is allowed to be selected and the data to be selected is in a recursive table, then the Selection TreeView should be used. An example of recursive data is the sites in the tSites table. In this table, the ParentID column defines which site is the parent site. For a site with no parent, the ParentID column is -1. The Selection TreeView then lists the data as a tree structure to provide a more organized view of the data.
The table below lists all the specific properties of the Selection TreeView.
| Specific Properties of Selection TreeView Controls | |
|---|---|
| Fieldname | Specifies the linked column in the respective table of the current Docusnap database. The meta object linked with the data entry screen determines which table will be used. The corresponding target column in the database must match for a Selection TreeView with the primary key of the list. |
| SourceType | This property specifies the type of data source to be used for the selection grid. You can either use database tables or the Docusnap reference values. For initial values there are no recursions, so in most cases a database table is used. For initial values the selection grid is more suitable. |
| SourceValue | Depending on the selected SourceType, enter either the name of the corresponding database table or the identifier of the desired reference value for this property. |
| Icons | For the Selection TreeView, an icon can be selected to be displayed in the data entry screen. If desired custom icons can be defined for different types. For example, for each system type (workstation, server, etc.) the appropriate icon. |
| ReferenceRecursionField | Here you can specify the existing recursion field to display the data of the recursive table as a tree structure. It is not necessary to use a recursion field. In this case the data is displayed in a flat list. However, the selection grid would be better suited to display data that does not have a recursion, because the selection grid also offers a filter and additional columns can be displayed. |
| Sorted | This option sorts the entries alphabetically according to the first column. If this option is not active, views will use the sorting specified in the statement, and tables will display the data in the order in which it was inserted into the table. |