Updated at: 2022-12-09 03:49:50
The dataset is sourced from the preset data connection, and the required field parameters will be aggregated for Big Screen & Report show.
The configuration as follows:
1. Click Server>Server Dataset, and click “+” to select the corresponding dataset type;
2. Taking database query for example, select the built JDBC connection, and the database tables data will show below. In the right query editor, input SQL statement for searching and defining field parameters as follows:
3. After the query result displayed, click OK to save the dataset.
_15.png)
Note:
1. Please refer to the link below for more details about configurations for database query.https://help.fanruan.com/finereport/doc-view-107.html；
2. Please refer to the link below for more details about JSON dataset query syntax.https://github.com/json-path/JsonPath
The configuration as follows:
1. Click Server>Server Dataset, and click “+” to select the corresponding dataset type;
2. Taking database query for example, select the built JDBC connection, and the database tables data will show below. In the right query editor, input SQL statement for searching and defining field parameters as follows:3. After the query result displayed, click OK to save the dataset.
Note:1. Please refer to the link below for more details about configurations for database query.https://help.fanruan.com/finereport/doc-view-107.html；
2. Please refer to the link below for more details about JSON dataset query syntax.https://github.com/json-path/JsonPath
< Previous:
Next: >