I. Overview
1) The Drop-down Tree widget, similar to the Drop-down Box widget and the Drop-down Checkbox widget, enables you to select one or more options for query.
2) The Drop-down Tree widget allows multi-level dropdown. For example, if options are employee names, by building a drop-down tree, both the names of departments and employees will be listed. These employees will be matched with the departments they serve in positions, and the employee names will be listed at the sublevel of the department names. If a department is checked, all the employees in this department will be checked.
II. Steps
1. Drag the widget
1) Click on the Checkbox Group widget and drag it into the parameter pane. The widget name defaults to checkBoxGroup0.
2) You are allowed to change the widget name. The widget name is used to bind the widget to a certain parameter. Specifically, the widget will be bound to a parameter when they have the same name. In the Preview mode, the values selected with the widget will be passed to the parameter.
2. Disable the widget
1) Check [Enabled]. In the Preview mode, you are allowed to check the options the widget displays.
2) Uncheck [Enabled]. In the Preview mode, the widget has a shallow color and you are not allowed to check the options the widget displays.
3. Hide the widget
1) Check [Visible]. In the Preview mode, the widget is visible.
2) Uncheck [Visible]. In the Preview mode, the widget is not visible.
4. Widget value: String
1) Widget value refers to the option selected by default in the Preview mode, which can be string, field or formula.
2) The default single options are Jiangsu, Chen Yu, Television, with layered separated by commas.
3) The default multiple options are Jiangsu, Chen Yu, Television, MP3, with layers separated by commas and values separated by semicolons.
4) Preview.
5. Data dictionary
The drop-down tree can be built by three ways: Fast Layered Build, Automated Build and Basic Layered Build.
6. Data dictionary: Fast Layered Build
1) Fast Layered Build-1
Both the actual and display values are set as region.
2) Fast Layered Build-2
Both the actual and display values are set as salesperson.
Set 1 dependent layer.
Set 1 dependent field: Region.
3) Fast Layered Build-3
Both the actual and display values are set as Product.
Set two dependent layers. Select 1 for the 1st dependent layer and 2 for the 2nd dependent layer.
Select Region for the 1st dependent field and Salesperson for the 2nd dependent field.
4) Preview.
7. Data dictionary: Automated Build
1) Automated Build-1
Select a tree dataset to build. The Automated Build function will build a drop-down tree by reference to the data from the tree dataset.
You may refer to the configurations for tree dataset.
2) Automated Build-2
Select the tree dataset that has been built.
Set the actual value to DepartmentID and the display value Department_name
Preview.
8. Data dictionary: Basic Layered Build
1) Basic Layered Build -1
Create three datasets. Take the table of sales volume from RDemoEN as an example.
Formula for the 1st dataset: SELECT DISTINCT region FROM sales_basic WHERE region !="" .
Formula for the 2nd dataset: SELECT salesperson FROM sales_basic WHERE salesperson !="" AND region = '${layer1}' .
Formula for the 3rd dataset: SELECT product FROM sales_basic WHERE product !="" AND region= '${layer1}' AND salesperson = '${layer2}' .
2) Basic Layered Build-2
Click on [+] on the left to add layer 1.
Type: Data query.
Dataset: 2-Basic Layered Build-1
Actual value: Region. Display value: Region.
3) Basic Layered Build-3
Click on [+] on the left to add layer 2.
Type: Data query.
Dataset: 2-Basic Layered Build-2.
Actual value: Salesperson. Display value: Salesperson.
4) Basic Layered Build-4
Click on [+] on the left to add layer 3.
Type: Data query.
Dataset: 2-Basic Layered Build-3.
Actual value: Product. Display value: Product.
Preview.
9. Basic Layered Build: High performance
1) If [High Performance] is checked, the drop-down tree will not traverse all child nodes, and each node has child nodes by default. Only when the [+] icon in front of the node is clicked, the drop-down tree will detect whether there are child nodes, making it faster to load such nodes.
2) If [High Performance] is unchecked, the drop-down tree will traverse all child nodes. If a certain node does not have child nodes, no [+] icon will appear in front of the node. Traversing all child nodes will also cause slower loading of such nodes.
10. Watermarks
1) Leave the box of field or formula in [Widget Value] empty. If you type a watermark text in the corresponding box in the right-hand pane, a light-grey watermark will be shown in the widget option box in the Preview mode.
2) After clicking on the widget, the watermark will disappear. So we can add watermarks to display texts or numbers.
11. Font size
1) You are allowed to change the font size.
2) The font size is 12 by default.
12. Multiselect
1) If [Multiselect] is checked, you can select check more than one nodes.
2) If [Multiselect] is checked, when you check a parent node, all child nodes will be checked.
3) If [Multiselect] is unchecked, you can only check one node.
4) If [Multiselect] is unchecked, there is no checkbox in front of the parent node.
13. Async load
1) If [Async Load] is checked, only parent nodes will be displayed in the Preview mode. Only by clicking on [+] in front of the parent node will all child nodes be checked.
2) If a large number of datasets are used, it is necessary to check [Async Load].
3) If [Async Load] is unchecked, all datasets will be expanded in the drop-down list.
4) If only a small number of datasets are used, it is not necessary to check [Async Load].
14. Return leaf
1) If [Return Leaf] is checked, when you check a node, all of its child nodes will be checked.
2) If [Return Leaf] is checked, the function is only applicable to the drop-down tree with multiple options, it will return an array as the return value.
3) If [Return Leaf] is unchecked, when you check a node, its parent node or child nodes will not be checked.
4) If [Return Leaf] is unchecked, the function is only applicable to the drop-down tree with multiple options.
15. Return path
1) If [Return Path] is checked, it will return all the matches in the return path and return an array as the return value.
2) If [Return Path] is unchecked, it will only return matches of the checked nodes.
16. Allow returning a null
1) If [Allow Null] is checked, it allows you to make a query without displaying any option.
2) In the Preview mode, no option is checked and no error tip pops up after clicking on Query.
17. Not allow returning a null
1) If [Allow Null] is unchecked, select at least one node for query.
2) In the Preview mode, if no node is checked and an error tip pops up on the right side of the browser window after clicking on Query.
18. Allow edit
1) If [Allow Edit] is checked, after clicking the drop-down box you are allowed to input values for fuzzy query.
2) If [Allow Edit] is unchecked, after click the drop-down box you are not allowed to input any value.
19. Allow custom data
1) If [Allow Custom Data] is checked, after clicking the drop-down box you are allowed to input a value that is in or not in the drop-down list.
2) If [Allow Custom Data] is unchecked, and if you input a value that is not in the drop-down list after clicking the drop-down box, there will be a pop-up window that reads the value is not in the drop-down list.
20. Widget position
1) Widget position refers to the coordinates of the widget in the parameter pane.
2) Manually input the widget coordinates or directly drag the widget to any position at your option.
21. Widget size
1) To resize the widget, put your cursor onto a border line and the cursor will change into a streamlined arrow, then click and drag.
2) Directly input the width and height of the widget.
