Hi, Peter.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Absolutely. You can use SQL Query based data for source of our dataTables,

and you can make charts from these kinds of tables.

You can also use data made from a VIEW in the database,

in our SQL Tables just call it as : "SELECT * FROM ViewName".

You can see more details how our SQL Tables work here.

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.

-

 In regards to making Charts :

You can check out all the available chart engines and examples of wpDataCharts documentation here .

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi, Peter.

It is not possible to enter an SQL Query in a chart Wizard.

When you go in the Chart Wizard with our plugin, in the first step we set up Chart Name and we choose the Chart Engine/chart type,

on the second step we have to choose a table as the data source,

so this table has to already exist in our plugin.

You would first need to make your SQL Query in an SQL Query-based Table,

and once the table is complete - you can choose it in the Chart as data Source.

Then, we choose which columns the chart should take to pull from that table.

The first one can be any Data type ( string,float or integer) , it provides the labels of the X axis,

and all other columns must be numeric.

You can check out all the available chart engines and examples of wpDataCharts documentation here .

-

Let me know if you have any further questions.

Thanks.

Hi, Peter.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

In the first screenshot, i can see you are showing a wpDataTable ID 1,

but this is probably not the same table name in your Database.

-

Please go in your Table #1 in our plugin, open the Editing Tab,

then check what is the "MySQL Table Name" there;

and search for this table name in your database?

-

If you made an SQL Query table in our plugin from selecting an SQL VIEW,

then it will be a bit different,

but i am not fully understanding your use-case.

-

Could i take a look from the back-end?

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And please send me access to your Database that you're pulling the table data from,

either an URL with credentials for PHPMyAdmin,  or access to the hosting panel of this database?

Thank you.