Common Template Parameter Combination

When there are many parameters, every time you open the template, you have to select each parameter and query again, which is very cumbersome. In most cases, the combination of parameters used by users is relatively fixed.

Therefore, in 10.0, the historical parameter combination can be saved, and the parameter combination can be intelligently judged and recommended.

Open template %fr_Home%/Webroot/WEB-INF/reportlets/Doc-EN/parameter/DB_Box_para.cpt

Dd_Box_para.cpt

Enter the editing status of the parameter pane, and check Use Parameter Combination in the property panel, as shown in the following figure:

Note: for 9.0 l 10.0 template, use Parameter Combination is not turned on by default; for 10.0 new template, use Parameter Combination is turned on by default.

Log in to the decision-making platform, such as an administrator or an ordinary user. After logging in, preview the template and set the common parameter combinations, as shown in the following figure:

Note: you need to log in to the decision system to display the parameter combination. Each user corresponds to the parameter combination set by himself

1. Save new parameter combination

Set the parameters: Region: North China, product types: Beverages, Product: Milk. Click Save the Combination to open the dialog box. Enter Name and click OK to save a parameter combination, as shown in the following figure:

Note: a user can only save up to 9 parameter combinations (including intelligent recommendation) in one template. If there are more than 9, a warning "save up to 9 parameter templates" will pop up

2. Modify the original parameter combination

Select Set1, change the product to Apple Juice and click Save the Combination to open the dialog box. Click Save, as shown in the following figure:

3. Sort

Select Set1 with the mouse, drag it to the middle of Set2 and Set3, and release the mouse. In this way, Set1 will move to the middle of Set2 and Set3, as shown in the following figure:

4. Delete

Select a combination, click Delete and confirm the deletion, as shown in the following figure:

5. Rename

Double click the combination name to rename the parameter combination, as shown in the following figure:

According to the user's historical operation record - used parameter combination (saved in fine)_record_Param table), which is recommended by default in the past seven days, and the number of uses in the past seven days is the top 2, and the number of uses in the past seven days needs to be greater than 7.From the start of the server, the first recommendation is at 00:01, and then every 24 hours, will be shown in the below location:

Note: saved combinations will not be recommended

1. fine_param_template

The combination of  parameters saved by different users is stored in  FineDB fine_param_template , as shown in the following table:

tpgroup uses JSON to store the encrypted recommended parameter combination information, which is as follows after decryption:

{
    name: 'xxx',
    data: {
        id1 : 'value1',
        id2 : 'value2',
        ...
        id9 : 'value9'
    }
}

name : The name of the recommended parameter combination

id : control id

value : actual value

Note: The order of the data in data is meaningful, the higher the front, the more commonly used, and the front on the interface.

2. fine_record_param

Store the historical usage details of different users  in LogDB  fine_record_param , as shown in the following table: