The Reports table is where the finalized report is stored and accessed. This table is where report shells are created, including:
Name of your report
Number of Widgets per Page
After this table has been uploaded into your environment, you need to update the Actions column:
Click on the Design Table tab
Navigate to Columns > Actions column
In the CQL Expression box, change the number next to ‘appId=’ to correspond with the Cinchy ID of the report applet created through this installation.
The Widgets table is used for configuring the actual report. This includes picking the report type (bar chart, line chart, pie chart etc), picking the report query, and attaching it to a specific report in the report table.
Get Chart Metadata Queries
This query if executed, will return the all the column values from both the widgets and reports table for a specific report.