Used to report. The requested information is displayed in the form of a tree list.
Tree List tool icon at Toolbox
How it looks like on the Canvas
Name: The name of the tool will be written here.
Text Size: Sets the size of the tool.
Help Text: It is the text that is entered for comment when the mouse is placed on the tool.
Height / Width: Adjusts the height and width of the tool (The width field has been removed from Responsive Forms).
From Left / Top: Adjusts the distance of the tool from the left and top (This field has been removed from responsive forms).
SQL Query: SQL queries will be written here.
Color Style (Field|Criteria|Value|Type|Colors|Cell (0-1)): The specified color is applied to the line or area according to the specified area information.
Sub Total (Field|Operation (count,sum,min,average)|Text): Makes the subtotal information appear under the list. For example; Quantity | sum | Quantity Total is the subtotal of quantities.
Hide Column Heading: Hides the column headings in the list.
Fit Horizontal: Fits the tool to the full screen on the user’s screen.
Pin Right: Pins the tool to the right.
Display: Makes the tool not appear on the screen.
Detail Button: Adds a detail button to the lines in the report.
When the row is changed: Assign an “Action” as on row value changes handler. For more information please click here.
When double-clicked on row: Assign an “Action” as a double click handler. For more information please click here.
As in the tree-list tool, it is necessary to add an event in the tree list tool. When the form is opened and Update Value operation is created for the tree list.
The output of this query will look like the following.
In the Search field, a search is made among the values in the list.
In this query, rows with IDs 1 and 4 can be considered as parent because the parendID fields are empty. Rows 2 and 3 are located below row 1 as the parentId field is 1. And again, since the parentID field is 4, the line with ID 5 and will be listed under line 4.
By clicking on the triangles on the left, the values in it are displayed.
To give an example about coloring;
Coloring example in the first row Columns with a value greater than 0 in the columns in the UserID column will be colored red.
Since a column name is not given in the second line, all cells are checked and the text color of the cells whose value is admin will be blue.
In the third line, since no column name is given, all cells are checked and the background color of the cells whose value is greater than 103 is grayed out.
Unlike the tree-list tool, the desired rows in the Tree List tool can be linked to the parent field with the value that will come to the parentID field at the end of the query.
List Tree can be thought of as a family tree. List If the line (parentID) to which it is bound is null in the tree structure (null) it will be listed as the parent lineage.