DHTMLX connector for .NET not working for complex queries

Suite and Optimus Suite 5
#1

Hi,

the following query is not displaying data in Grid

SELECT Region, Year, ‘EPC’ Family, ‘Total’ Total, Sum(Units) as [Units] FROM tblFinancials WHERE Region = ‘USA’ AND X6_Desc = ‘EPC’ GROUP By Region, Year

but if i modify the above query as below:

SELECT Region, Year, Sum(Units) as [Units] FROM tblFinancials WHERE Region = ‘USA’ AND X6_Desc = ‘EPC’ GROUP By Region, Year

then it works fine, i just omit ‘EPC’ Family, ‘Total’ Total from the query. Do Grid connector support such queries?if yes then is there some other parameters to set?

#2

Try to use following query:

SELECT Region, Year, 'EPC' AS Family, 'Total' AS Total, Sum(Units) as [Units] FROM tblFinancials WHERE Region = 'USA' AND X6_Desc = 'EPC' GROUP By Region, Year
#3

I tried this, but it not working

#4

This issue confirmed and will be fixed at the next version of dhtmlxConnectors .net. If you need updates sooner please open ticket at support.dhtmlx.com