11-13-2013 04:43 AM
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
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