Community
Showing results for 
Search instead for 
Do you mean 
Reply

Dashboard and Custom Tables

Copper Contributor
Posts: 29
Country: Germany

Dashboard and Custom Tables

Hallo,

 

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>