we have a custom table "CUST_Systems" and would like to have it included to the dashboard.
I added the following item to the Act.Dashboard.DataChart.xml but it does not show data.
The SQL Statement is valid and tested in the SQL environment.
Whats the correct way to include custom tables to the dashboard?
Thanks for any idea in advance Susanne
<item> <key> <string>Custom Tables</string> </key> <value> <string> SELECT COUNT(*), Company.NAME AS FName, CUST_SYSTEMS.CUST_Seriennummer_094118254 FROM CUST_Systems INNER JOIN CUST_COMPANY_SYSTEMS ON CUST_Systems.SystemsID = CUST_COMPANY_SYSTEMS.SystemsID INNER JOIN TBL_COMPANY as Company ON CUST_COMPANY_SYSTEMS.COMPANYID = Company.COMPANYID GROUP BY Company.NAME, CUST_SYSTEMS.CUST_Seriennummer_094118254 ;0;FALSE</string> </value> </item>