FVS Query Panel

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

Version

Application Scenario

In FVS templates, parameter widgets for data query need to be directly added to the canvas before being used.

However, in some cases (especially when you need to view templates on mobile terminals), you may want the widget query panel to be collapsible and expandable, rather than to be directly displayed in templates.

With the FineVis Data Visualization plugin of 2.3.0 and later versions, you can achieve the above need by enabling the query panel, as shown in the following figure.

Note:

Widgets on the query panel are not subject to widgets on the canvas. No linkage effect exists even between widgets with the same name on both the query panel and canvas.

Function Entry

The query panel setting is shared by all pages. The setting entry is in the page area below the canvas. Click Query Panel Setting. The setting page pops up.

You can select Enable Query Panel (deselected by default), add widgets on the query panel, and set the query panel style, as shown in the following figure.

After you enable the query panel and add widgets, the query icon appears in the bottom left corner of the preview page. If multiple pages exist in the template, the query icon is displayed on the left of the page switchover icon.

Note:

If the query panel is enabled but no widgets are added, the query icon will not be displayed on the preview page.

Content

Click Add Widget, select a widget from the drop-down list, and set the widget content on the right.

Note:

You cannot set character styles for widgets on the query panel.

You can adjust the order of widgets (namely the display order of widgets on the preview page) by dragging.

Style

You can determine whether to select Enable Auto Query in Style.

If you select Enable Auto Query, the query panel will collapse by default when you preview the template for the first time or refresh the template. The widget query will be automatically triggered and all template contents will be displayed.

If you deselect Enable Auto Query, the query panel will be expanded by default when you preview the template for the first time or refresh the template. The template content will not be displayed and you need to click the query icon for display.

Note:

The overall styles of the query panel and widgets are affected by the FVS template theme.

Template Preparation

Choose File > New FineVis Visualization Dashboard in the upper left corner of the designer and create a blank dashboard.

2. Create a database query named ds1 and enter the SQL query statement SELECT * FROM SALES_BASIC where Region='${area}'.

Set the default value of the parameter area to Jiangsu Province. That is, the sales data from the Jiangsu province is obtained by default.

Column Chart Adding

Click the Chart icon in the component area and click Column Chart to add the column chart component to the page. 

Bind data with the area parameter in the dataset to the column chart, as shown in the following figure.

Query Panel Setting

Click Query Panel Setting below the canvas, select Enable Query Panel, click Add Widget, and select Dropdown Box from the drop-down list.

Set Name to area and Type Setting in Data Dictionary to Custom, add actual values and display values, set Default Value to Custom String, and enter Jiangsu Province.

Keep the default setting in Style, where Enable Auto Query is selected by default.

Effect Display

PC

Click Save in the upper right corner and click Preview. The query icon appears in the bottom left corner of the template. You can click the icon to expand the query panel, as shown in the following figure. 

Mobile Terminal

For details, see FVS Mobile Attribute. The dashboard is shown in the following figure.

You can download the example template FVS Query Panel.fvs.