FVS Dropdown Tree Widget

  • Last update:October 23, 2023
  • Overview

    This document is applicable to users who have installed the FineVis Data Visualization plugin to learn plugin functions.

    Version

    Report Server Version

    Plugin Version

    Functional Change

    11.0.16

    V1.X

    /

    11.0.16

    V2.0.0

    Optimized the Content tab page in the widget.

    Function Description

    In a dropdown tree widget, you can select options in the dropdown list during template preview to link with other components through parameters. The effect is shown in the following figure.

    Note:
    • The function is not supported on mobile terminals. 

    • Widget name is set in Content.

     

    Functions

    Widget Content

    The setting items in the Content tap page of the dropdown tree widget are shown in the following figure.

    The following table describes these settings.

    Settings

    Introduction

    Name

    Widget name, namely the parameter name, with the default name in English

    You need to modify the name according to the actual parameter.

    Font Size

    Font size of the text displayed in the dropdown tree, defaulting to 12 px

    This setting does not affect the font in the dropdown tree options.

    Data Dictionary

    Actual value and display value of the drop-down tree can be set. There are three creation methods, including Automatic Creation, Basic Layered Creation, and Fast Layered Creation.

    Option

    Multiselection (unticked by default):

    If it is ticked, you can select multiple options in the dropdown tree. If it is unticked, you can select only one option in the dropdown tree.  

    After it is ticked, The result returns only leaf nodes (ticked by default) can be used to determine whether child nodes are automatically selected when parent nodes are selected.

    If The result returns only leaf nodes is ticked, all child nodes are automatically ticked when the parent node is ticked, and the parent node is filled with a colored block when child nodes are ticked.

    If The result returns only leaf nodes is unticked, all child nodes are automatically unticked when the parent node is ticked, and the parent node is not filled with a colored block when child nodes are ticked.

    Asynchronously expand tree nodes (ticked by default):

    Node loading logic, affecting performance

    If it is ticked, only data of the parent nodes are loaded and all child nodes remain collapsed by default after the options are expanded. This is suitable for cases with big data.

    If it is unticked, all child nodes are expanded at once after the options are expanded. This is suitable for cases with small data.

    The result returns only leaf nodes (ticked by default):

    In hierarchical dropdown tree widget, each leaf node at the bottom level has its full hierarchical path.

    If it is unticked, return only leaf nodes. For example, select Phnom Penh, and the return value is Phnom Penh.


    Return full hierarchical path (unticked by default):

    In hierarchical dropdown tree widget, each leaf node at the bottom level has its full hierarchical path. The returned value is the array-type data.

    If it is ticked, return the full path. For example, select Phnom Penh, and the return value is Southeast Asia, Cambodia, Phnom Penh.

    Return

    The Return option appears only when Multiselection is ticked and Return full hierarchical path is unticked. This option is used to set the format of the return value for the  multi-select dropdown tree, with the Array and String formats.

    • Array: The return value is an array. For example, select three values, and the return value is "Value 1", "Value 2", "Value 3".

    • String: The return value is a string, in which separator, starting symbol, and terminator need to be defined. That is to say, multiple selected values are concatenated into a single string through the separator. You can manually enter or directly select these symbols. For example, the separator is defined as a comma (,), and the starting symbol as well as terminator are both defined as single quotes ('). Then the return value is 'Value1,Value2,Value3'.


    Default Value

    Default value displayed in the dropdown tree widget, with the following three types:

    1. Custom String: You can directly enter text.

    For example, to select Phnom Penh, enter Southeast Asia,Cambodia,Phnom Penh. Separate the child and parent nodes with a comma (,).

    If Multiselection is enabled and multiple values need to be entered, separate child and parent nodes with a comma (,) and separate values with a semicolon (;). For example, to select Phnom Penh and Dili, enter Southeast Asia,Cambodia,Phnom Penh;Southeast Asia,East Timor,Dili.

    2. Field: You can select fields from the dataset. If a field value conforms to multiple value formats and Multiselection is enabled, the default value will be selected for multiple options.

    3. Formula: Click fx on the right to enter a formula. For example, use the formula =Table1~A1 or =[[1,11,111],[1,11,112]] to retrieve the value of cell A1 in the Table 1 component.

    Watermark

    Light gray watermark text displayed in the widget during preview, serving as a prompt for the required information. It disappears after an option is selected or text is entered. Watermark's input box is empty by default.

    Permission

    The Editable option (ticked by default) determines whether the widget is editable during the initial preview of the page.

    Validation

    Null Value Validation (Allow Null is ticked by default.): used to determine whether the widget can be empty.

    • If Allow Null is ticked, the widget can be empty.

    • If Allow Null is unticked, validation prompt text can be set. If the widget is empty during template preview, the prompt text is displayed.

    Custom Value Validation (Allow Custom Value is ticked by default.): used to determine whether users can enter values that are not included in the dropdown box options.

    • If Allow Custom Value is ticked, users can directly enter a value to achieve fuzzy search when selecting a value from the dropdown tree box.

    • If Allow Custom Value is unticked, the entered value is automatically cleared in the dropdown tree box when it is not included in the dropdown options.

    Widget Interaction Event

    Choose Interaction > Add Event to add JavaScript events to achieve more effects. After Initialization and After Exiting Edit events can be added in the dropdown tree widget.

    Click a specific event. Then the JavaScript event setting box pops up.

    Attachment List


    Theme: FineVis Data Visualization
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy