Hi Colleen,

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.

-

I presume this is related to the same issue as you described on your original Private ticket https://tmsplugins.ticksy.com/ticket/3507787?

There is no maximum limit when it comes to rows in our SQL Tables.

On this Page you can see our SQL Table which is made from Data Set of  2.560.000 rows and see how it loads.

The only limits will come from your Hosting Server configuration and WordPress configuration.

In our SQL Tables, when you have more than 2 thousand rows, our server-side processing feature is enabled automatically, that helps with server load by using Admin-Ajax calls to just load one Table Page at a time.

So please check in your Table Display settings, and do not set "All" as the default number of rows to load per page.

Set anything other than that, such as 100 rows or less and check again.

-

If you still get just a spinning loader, your Hosting firewall might be blocking our Plugin's Admin-Ajax call, but we know how that can be solved, if that is the case, then your Hosting should be able to easily solve that for you.

The best is if you can open your Browser Developer Console/ and keep the Network Tab opened;

Then check when that spinner load happens, does it give a "preview text"?

If it says something like "Blocked by hosting firewall" we can advise you on it.

I also asked for access on your original ticket - so if this is the same issue, it's best to just reply there and we will keep following up.

Thank you.

Hi Colleen,

To begin, I want to extend my heartfelt apologies for the delayed reply, 

which is due to an unexpectedly high volume of inquiries. 

We truly value your patience during this period.

1.  I can see an SQL Table loading on that Page, that is good to see.

2. I am using a foreign key to determine the "PL Code". The adjusted price needs to be "Price" * 'PL Code'

How can I do that?

-

In order to use a Foreign Key Column with our Built-in feature, it must be set to a String type Column, so you will not be able to use it in a Formula or a Calculation Function, unfortunately.

In our Formula Column - you can only use Numeric Columns at the moment.

If you can find any alternate way to somehow call that SQL Column directly from your Database and have it as a Numeric Type in our Table, then you will be able to add it to a Formula - but if it needs to be a String/as Foreign Key Column, then unfortunately, right now we do not have a solution for that scenario.

At this time, we don't have any built-in solution to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.

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.

-

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)

Hi Colleen,

Sorry for the delayed reply.

If you use CONCAT for any field in your SQL Query, you will need to exclude that field from "Global Search" to avoid issues with search/filtering.

Then, if there are not any other SQL functions in your Query that cause any other issue with our SQL Parser, you should be able to use filtering for Cascading Filters.

But i am not sure exactly how you constructed your Table and the Chart, it is best if we can take a closer look at the Page and the back-end setup for the source Table and the Chart.

Can you please send me an URL to the Page where you have the Chart with the Table filters?

And if possible, if you can record a short Video just so we can see which filter you choose when the issue happens?

If the Video becomes too large for this ticket, you can upload to weTransfer and send me a download link.

And for the back-end access,

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.