Hi, David

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.

-

Yes, there are separate database connections for MySQL, MS SQL and PostgreSQL databases.

Please check out this page that explains how to use this functionality.

Let me know if you need any assistance. Thanks

-

Just wanted to point out that we have a sandbox/Demo site (https://sandbox.wpdatatables.com/), that you can use to try out some of the plugin's features;

and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out,
we will assist along the way,
and if it doesn't fit your needs you can request and receive a refund in that period.

Hi, David

For this, i have to double-check with my senior colleagues at the 2nd level Team, in order to give you most accurate information.

As soon as they confirm it for me, I will come back to you straight away. Thank you for your patience.

Hi, David

Apologies about the delay, we had a small break to celebrate Orthodox Easter, so it has slowed down our work pace.

-

I'm searching to find the best advise for you - one of the possibilities i am considering is that you could try to avoid subqueries by splitting them into separate Views, and then merging them into one View, or combining selection of multiple Views, in order to get a "simpler SELECT" statement for our plugin and to ensure working filters.

I am still going to double-check that and the previous points that we talked about, regarding advice on  creating more complex SQL queries, based on the example you have sent us - i will get additional help from developers to be sure.

- They will be back in the office tomorrow, so i will do my best to confirm as quickly as possible, and I'll get back to you on that.

-

In the meantime, i can give you some useful information about our PHP & SQL parser:

In some situations, using certain functions within SQL, the wpDataTables server has problems with parsing the query and building new queries dynamically (rarely happens, but does sometimes).

Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types:

1.    SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them like DROP and DELETE, though, are disabled for security reasons.

2.   Using variables ( @ ), stored procedures and nested queries is not supported, but you can prepare a MySQL view (which will return the data you need); call it “view1” for example, and then build a wpDataTable based on a simple query like “SELECT * FROM view1”.

3.    For MySQL engine we are dynamically adding the accent grave ( ` ), so there’s no need to use it around the table name in the query.

-

Regarding chart filtering, as you probably saw, i guess you watched this video;

if you switch on "follow table filtering", and you set both the table and chart on same page, it should work.

-

We can help you hide the table, but have filters show, and the chart on the page, with some custom CSS:

You would first need to disable the following in table settings:

"Show X entries" drop-down; "Info Block" from Display tab:

Then enable main "search block" and "Show filters in a form above Table" from the Sorting and Filtering tab:

Then, you can hide the table, leaving only the filters and the chart visibe like this,

insert this custom CSS in the Customize tab of the table settings:

.wpdt-c .wpDataTablesWrapper table {
display: none !important;
}

And here is an example, a page with a table and a chart, with filtering above the table(without hiding):

Now when we add the CSS, the table is hidden, but you can still filter the chart:

This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.

-

Let me know if anything was not clear regarding hiding the table;

and for the other points i will still confirm them for you, regarding MySQL queries. Thanks.

Hey, David

Sorry about the delayed response again

Thank you for your patience and cooperation on all the points.

I am happy to see that you have advanced towards the full solution, and fingers crossed that you get all the remaining bits and pieces of the puzzle, of course.

-

Regarding everything translating over to PostgreSQL as the same as MySQL, to be honest, i can't confirm it with 100 % accuracy, but it should work.

-

Regarding the charts angle, i checked that with our senior 2nd level Team, and unfortunately, we don't have a working example for what you described as in a label at the end of each bar, saying what the value is ( instead of relying on the tooltip to show the value).

We haven't had the chance to test something like that yet.

But i can see that you've figured out the Highcharts example, so basically, using the same methodology, you should be able to manipulate and customize more functionalities/details of the chart engine behaviour.

-

That is the default behavior of the charts engine, but if you need some custom solution you can check our documentation about wpDataCharts callbacks. 

• Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API. 

• All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")

Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.

Hi, David

Sorry for so much waiting time on the response.

-

I am not sure, to be honest, i haven't personally had experience with the "median" functionality yet;

but i will certainly escalate this, and i will get confirmation if what you described can be done with our plugin.

-

Regarding hiding the table when it is on the same page as the chart, to have that filtering capability but hide the table, i can give you some custom CSS;

We can hide the table using CSS, leaving only the chart and the filters. 

Since you need to show the filters, a simple CSS like this would not be useful, because it'd hide the filters too:

.wpdt-c .wpDataTables.wpDataTablesWrapper {
display: none !important;
}

So, instead, we would first need to disable the following in table settings:

"Show X entries" drop-down; "Info Block" from Display tab:

Then, "Enable main search block"  and "show filters in a form above the table" from the Sorting and Filtering tab:

Then, you can hide the table, leaving the filters above the chart like this:

<style>
.wpdt-c .wpDataTablesWrapper table {
display: none !important;
}
</style>
[wpdatatable id=1]
[wpdatachart id=1]

This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.

-

Let me know how that goes, and of course, i will still get back to you about the other point in question.

Thank you

Hi, David

My sincerest apologies for all the delay that happened for confirming about functionality of medians.

The developers have confirmed that, unfortunately at this moment, our SQL & PHP Parser does not support use for medians.

But please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Once more, apologies for all the time passed. Thank you very much for all your patience.