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.
From Left / Top: Adjusts the distance of the tool from the left and top.
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.
The rows with IDs 1 and 6 in this query can be considered as the parent lineage because the parendID fields are empty. The line ID of 2 will be listed below line 1 because the parentId field is 1, and the line with ID 5 will be listed below line 4 because the parentID field is 4.
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.
For example, in the following query, the id and parentID fields will not show the id and parentID fields but will be used for operations within the list.