MySQL (ODBC connection) data source table fetch

[Ilya Bo]

Hi,

Hi is it possible to provide build of dashboard platform which MySQL (ODBC connection) data source uses following query to fetch the tables:

select table_schema, table_name FROM information_schema.tables where TABLE_SCHEMA='schema_name' and table_type = 'BASE TABLE';

instead of:

select table_schema, table_name FROM information_schema.tables where TABLE_SCHEMA='schema_name' and table_type = 'base table';

i.e. table type in upper case: 

table_type = 'BASE TABLE';

That makes sense for me because I use PlyQL (MySQL Gateway) as data source which is case sensitive (MySQL is not sensitive).

So as the result MySQL data source will support one more data source.

Thanks!

[Umapathy Shanmugam]

Hi Ilya, 

 

Thank you for contacting Syncfusion support.  

 

We are analyzing about Plyql language and your requirement with our dashboard application. We will get back to you with analysis details on coming Friday (28.07.2017). 

 

Regards, 

Umapathy S. 

[Umapathy Shanmugam]

Hi Ilya, 

 

Thanks for your patience.  

 

We have did analysis over PlyQL(MySQL gateway) and came to know that currently PlyQL does not work for some of the features like 

 

1. Sub-queries in WHERE clauses
2. JOIN support