Hello,

We will advise which Plan you need and how to achieve what you described.

For example, in the starter licence, you won't get SQL Query based Tables, Google Sheets API, Front-End Editing and more.

You can compare the features between all Plans from Lite(free), then Premium versions from the Starter all the way up to the Developer Level, in the Plugin back-end Dashboard, under "Lite vs Premium".

You can also see this on the pricing Page, but here in the Dashboard, we show more details about each specific feature, etc.

If you don't have any installation now on your WordPress, you can easily see this on our Demo Sandbox Website.

For your specific Use-Case, you will need a Pro licence.

I understand you don't need more than one Domain - but the lower licences (starter and standard) don't have all the features you need.

You need the SQL Tables feature;

As well as "Separate Database connection";

And HighCharts Engine, because only the HighCharts has an export module for PDF and Excel.

1. You can see the Documentation here how you can use our SQL Query based Tables;

2. Here you can see how you can make additional Database connections;

3. Here you can see all our available HighChart standard types of charts.

With the Pro licence, you also get the HighChart Stock type charts.

I will advise about the Export features for HighCharts :

HighCharts is the only one that currently has the PDF export, as far as i can see - and these other export options are available for it :

  The only other engine that has some export features is the Apex chart engine, but it does not have PDF :

Every chart engine has its own layout and its settings.

We use free libraries for chart engines, and they are limited as to what we can change from within the plugin's UI.

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

4. Now, about setting up filters for a Chart ( as you described, so that a user can choose a date range on front-end) :

By default, the charts will not follow any filtering from their source table if you just put the chart "on its own" on the page.

But If you place the source table together with its chart on the same page,

and activate " Follow Table filtering"  on the chart Wizard settings,  it is going to follow any filtering/sorting you do on the table.

-

Now, depending if you wish to hide the table and have a filtering for Charts, we can have two workarounds available.

1. If you wish to hide the entire table along with table filters;

you can add this CSS to the table's back-end settings/Customize/Custom CSS.

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

This will completely hide the table from the page, but you can still pass the table shortcode with the chart, and you will get the "follow table filtering" effect on this chart.

2. Or if you wish just to hide the table while leaving the filters with the chart,

we would first need to disable the following in the 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 add this CSS in the table settings/Customize/Custom CSS:

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

That will just leave the chart visible with the filters on the page,

if you pass both table and chart shortcodes.

5. You also mentioned that the table should limit the rows/filter the Table to only show the rows for the currently logged user ID.

There are two ways to achieve it, depending if you use an editable table or not.

If you will use SQL Query based tables, please check this feature, which is our easy out-of-the box solution to limit each user to only see their User ID rows.

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 Jhonsent Marilao,

We will help you purchase the licence.

1. First we will advise about possible PayPal issues :

The reseller that we use (Paddle) has a limitation when it comes to PayPal. 

All subscription purchases (yearly licenses) made via PayPal need to be associated with a credit card, whereas PayPal balances can only be used for one-time purchases (lifetime licenses).

This is a security measure because a card is linked to your bank account, and it can automatically be charged every year for license renewal, whereas the PayPal balance can be depleted and never recharged since it's not linked to the account. 

That's why a card is mandatory for yearly subscription purchases.

Unfortunately, we have no control over this, since it's a limitation imposed by our reseller.

2. Or, if you decide to try via a card and if it gets declined while it should not be :

There is a chance that the bank of that card has declined a transaction, if the bank security system somehow flags it as a "fraudulent charge", by mistake.

The best to do is to contact the bank that issued the card, to let them know this transaction was not a fraudulent charge, and that you need it approved; then next time when the card is tried, it should go through.

Let us know how it goes, we will be here if further advice is needed after that.

Hello,

At this time, we don't have any other payment method, because the subscription system needs to link a card for the auto-renewal.

You should be able to easily fix this issue by contacting the bank which issued the card.

There is a chance that the bank of that card has declined a transaction, if the bank security system somehow flags it as a "fraudulent charge", by mistake.

So, the best solution to try is to contact the bank that issued the card, to let them know this transaction was not a fraudulent charge, and that you need it approved; then next time when the card is tried, it should go through.

Let us know how it goes, we will be here if further advice is needed after that.