[Direct] Add parameters to the dashboard URL directly

1.1 Version

1.2 Problem description

In the integrated environment, users need to directly add relevant parameters when opening the relevant dashboard URL of the store, such as  

http://xxxxxxxx&COUNTRY=China (version before 5.1.11); http://xxxxxxxx? COUNTRY=China (5.1.11 and later versions) filter out the data whose "COUNTRY" is "China".

1.3 Implementation ideas

Add parameters to the SQL dataset.

Directly add parameter conditions in the front-end dashboard to realize the data filtering function.

If you need to pass parameters through the filter component, see: filter component as a parameter to participate in calculation, jump to filter component to pass parameters.

2. Pass a parameter

2.1 Add SQL dataset

Create a new SQL data set with parameters in the business package:

SELECT * FROM CUSTOMER WHERE COUNTRY IN ('${COUNTRY}'). ${COUNTRY} is the parameter variable to be set, click "Refresh", set the default value of the parameter as "China", set the parameter type to text type, click "Preview", and confirm to save the dataset, as shown in the figure below :

2.2 Create Dashboard

Create a new dashboard, select the created SQL data table "customerinfo" with parameters, drag in the "COUNTRY" and "Counter" fields, and select "group table", as shown in the following figure:

2.3 Passing parameters

2.3.1 Public link passing parameters

To implement the parameter passing filter in the URL, you first need to obtain the URL of the dashboard. Enter the dashboard node, select "Share Link" for the newly created dashboard, open the public link and "Copy Link", as shown in the following figure:

Add "&parameter name=parameter value" after the obtained URL

Before version 5.1.11, for example, the obtained link is:

http://localhost:37799/webroot/decision/v5/design/report/share/085cfd6b620c441eae930b9ad709e717?link=eyJhbGciOiJIUzI1NiJ9.eyJyZXBvcnRJZCI6IjA4NWNmZDZiNjIwYzQ0MWVhZTkzMGI5YWQ3MDllNzE3IiwidXNlcklkIjoiYjVmMGMyZWUtNjQwZi00MDM5LWE0ZDQtOTE4YjU1MzU0ODk4IiwianRpIjoiand0In0.19qCbrS1Mlpr9unY30Sk02p4Y1PbS1fv2xIAu3VfMBk

Add "&COUNTRY=China" at the end:

http://localhost:37799/webroot/decision/v5/design/report/share/085cfd6b620c441eae930b9ad709e717?link=eyJhbGciOiJIUzI1NiJ9.eyJyZXBvcnRJZCI6IjA4NWNmZDZiNjIwYzQ0MWVhZTkzMGI5YWQ3MDllNzE3IiwidXNlcklkIjoiYjVmMGMyZWUtNjQwZi00MDM5LWE0ZDQtOTE4YjU1MzU0ODk4IiwianRpIjoiand0In0.19qCbrS1Mlpr9unY30Sk02p4Y1PbS1fv2xIAu3VfMBk&COUNTRY=China

Enter the URL with added parameters in the address bar, and you can see that the parameters in the URL are passed to achieve the filtering of "Management Store", as shown in the following figure:

Note: If the browser does not support Chinese parameters, that is, the parameter transmission filter does not take effect, you need to encode the json type url parameter value first encodeURIComponent(). For example, the edge browser.

After version 5.1.11, for example, the obtained link is: http://localhost:37799/webroot/decision/link/3Oth.

Add "?COUNTRY=China" at the end: http://localhost:37799/webroot/decision/link/3Oth?COUNTRY=China.

Enter the URL with added parameters in the address bar, and you can see that the parameters in the URL are passed to achieve the filtering of the "China".

2.3.2 Preview link passing parameters

Add "? parameter name=parameter value" to the URL of the dashboard preview, and you can also pass parameters.

For example, click "Preview Dashboard" to get the preview URL, as shown in the figure below:

Add "?COUNTRY=China" after the preview URL, you can see that the data of the country China is filtered out in the group table below, and the parameter transfer function is realized, as shown in the following figure:

3. Pass multiple parameters

When there are multiple parameters, the URL can also add parameters to achieve the effect of multiple condition filtering.

3.1 Add SQL dataset with multiple parameters

Add a SQL dataset, and enter a SQL statement with multiple parameters:

select* from CUSTOMER where COUNTRY in ('${COUNTRY}') and CITY in ('${CITY}')

Click "Refresh", set the default values to "China" and "Wu Xi", and save the dataset, as shown in the figure below:

3.2 Create Dashboard

Use the fields of the data table to create a component, including the "COUNTRY", "CITY", and "Counter" fields. The field values displayed in the component are all parameter default values. As shown below:

3.3 Passing parameters

Refer to section 2.3 to obtain the link of the dashboard, and add multiple parameters and values after the obtained URL:

For example, the obtained preview URL is:

http://localhost:37799/webroot/decision/v5/design/report/4c2c026273b74106be5def55a58ea067/view

Add the parameter "?COUNTRY=China&CITY=Wu Xi", and the URL after adding the parameter is:

http://localhost:37799/webroot/decision/v5/design/report/4c2c026273b74106be5def55a58ea067/view?COUNTRY=China&CITY=Wu Xi

After adding parameters, the dashboard can directly filter out the corresponding parameter values, as shown in the following figure: