Hi Mark,

I see what you mean - if I try to load any of the SelectBox dropdowns, it does take a couple of seconds to load them, while the table is not large/ does not have many rows and there are only a couple of defined values.

It could be some sort of a conflict, caused by a Caching/optimization plugin if you have some specific options configured on it/ or possibly a slowdown caused by something else on the Site.

Can you please check how this Table and filter behaves on the Back-End preview in the WP-Admin?

Is the table quick and behaves as expected there - but the issue is just on Front-End?

If that is the case, check if you have server-side processing option enabled in this SQL Query Table on back-end.

Disable the server-side option, then clear cache and refresh your Front-End Page, try again and see if now it loads the filter values quicker?

If it does, can you show me the SQL Query that is pulling the Data for this table?

And also, please check do you have any Caching active on your Page.

When you have server-side option enabled, and active caching on the page where a server-side Table is;

We currently have this issue which only happens for server-side processing tables when you have caching active on the page.

Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.

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.

-

For the time being, the only solution will be either to disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.

Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.

Or you can try disabling server-side processing in your Table.

Let me know if that helps and if you have any questions. 

Thank you

Hi Mark,

I believe we should take a closer look at your Table's back-end to try and debug the issue for you.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, and FTP Credentials;

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, do we have your permission if we need to disable/enable any other Plugins or change the Theme?

If this is a Live/production Site, and if you don't want us to troubleshoot there;

would you be able to provide us with a Staging site, along with WP-admin (Administrator) user,

 FTP credentials

 and the database access ( Either link with credentials for PHPMyAdmin or Hosting Panel),

 so our developers can debug the plugin, and see what's going on?

Thank you.

Hi Mark,

In regards to the CheckBox versus the SelectBox slow load issue;

we are happy to see that can work as a solution in your case.

In the meantime, I can confirm it is the same slow load for any SelectBox to load possible values on our end, too, so this is something coming from our Plugin itself.

I tried server side and non server Side Tables, and for all of them, it does take 2 to 3 seconds to load SelectBox Values - regardless if we set them manually or just pull the default values;

My short Video recording of that here.

 So we will pass this to our QA Team, the developers will do their best to add new improvements which would speed up the SelectBox loading time;

but for now, there is no way to have it quicker - our Plugin needs two to three seconds to load the available SelectBox Values.

You can use the CheckBox as a temporary solution until we improve the SelectBox loading speed.

 We don't have an ETA on when the improvement for the SelectBox loading speed will be available, but please keep a lookout on our wpDataTables changeLog.

It will be stated there during updates which bug fixes have been implemented at each update. If they create a fix in between updates, I will make sure to send it to you.

Sorry for the inconvenience.

Hi Mark,

We could still investigate this on your Site, just to have a good comparison with how the loading speed is on our Test Sites.

 The loading speed in general depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.

So if you could send us Access to check out your Back-end setup, that could help us with future improvements.

If you wish, you could send us an Administrator User credentials, so we can remote in and check out more details and how your WordPress is configured, etc.

If you send us access, just make sure it is in a PRIVATE reply, for security reasons.

Thank you.

Hi Mark,

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.

-

You can use my Email for an Admin account as [email protected].

2. Does the masterDetail addon allow tables (not the master) to be added to the popup?

If you mean to load data from a different Table inside the Master Detail pop-up, we don't have a built-in solution, but there can be a custom workaround if you have a "master-child" relation in two SQL Tables.

Here is an example provided by our developers :

First, you need to create that button (master-detail) column in your existing table with Master-Detail add-on and then set a custom page (post) where users will be redirected after clicking on the button.

Then, on that custom page, you will insert a table created with an SQL query and using placeholders.

If you have that table in the database then you will use it for creating a new table with an SQL query and placeholders.

If you create a manual table then you will use the table that is created in the database (you can find its name in the Editing tab under "MySQL name table for editing"). 

Those database tables have names like wp_wpdatatable_1,wp_wpdatatable_2... (where wp_ is the default prefix of the database table, but on your end, it could be anything, so look for your_prefix_wpdatatable_1...).

Then, use that table's database name to create a new one with a query. 

So you will create a new table like this

SELECT * FROM table_name_from_mysql_name_option WHERE column_name = %VAR1%

Then on that custom page, you would insert some default column_name value in shortcode like

[wpdatatable id=1 var1=test]

Now hooks. You will add this hook in your functions.php of your child theme or theme, depends on what you are using, to filter this var1.

And then you will use our hook for dynamically updating placeholders:

function updateVAR1($tableID){  global $wdtVar1;
      // check is set details data from POST, where you'll find all row data
      // from MasterDetail after button click in first table
    if(isset($_POST['wdt_details_data'])){
        $detailsData= json_decode(stripslashes($_POST['wdt_details_data']), true);
    // instead of origin_header you will insert value from your column origin header
    // on Master-dettails docs you will find Instructions how to create custom
     // template (post or page) and below that is shown what is origin header
       $wdtVar1 = $detailsData['origin_header'];
    }
      }
add_action('wpdatatables_before_get_table_metadata', 'updateVAR1');

This is the only way because the shortcode is executed before the content on the page or post.

Like this when the user clicks on the More details button (that you will create with Master-Detail) it will be redirected to your custom page (that you set in MD).

On that page, you will insert the shortcode of the Child table created from the query and placeholder.

After loading the page, the column value will be replaced with a placeholder, placeholders will be replaced in the query and you will get a table that is filtered with that placeholder.

I hope that I haven't confused you with this, but I try to be as detailed as I can so you can understand what and how you can achieve with this.

Let me know if this fits your needs.

Please note that using hooks requires certain level of programming skills and included support refers only to advice.

Hi Mark,

The only solution for something like that is the one which i passed from our developer;

the custom workaround to call another table as the master-child relation in the Master Details.

If we understood, you would be able to create a solution as advised, but it seems you need a more precise format/ more elegant solution, for your own custom detail page with a custom function?

I am truly sorry to disappoint you on that point, that goes above the level of what our Support can provide.

We did our best to search through all our available working examples,

and unfortunately, we don't have any example to show you for something similar to that specific use-case.

We also don't have any built-in solution to achieve this at this time, 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.

Maybe this can be done with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.

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

Hi Mark,

The solution you are trying to achieve falls under custom work.

Our support does not cover any custom work, we can only help when an issue happens with our Built-in 'out of the box' features.

If you wish to see a built-in solution for your use-case in the future, you can make a development suggestion.

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.

-

For the time being, we do not have any custom workaround to achieve what you need.

I will still ask our developers to see if they have any useful advice, as you said in terms of how to identify the ElementID of the table for your solution.

When they get the time to inspect this, I will report back to let you know if they can advise.

I can't say an exact ETA and we can't promise anything, but we will do our best to advise as much as we can.

I also wish to add, our developers are working to add more custom hook examples to our Documentation for Developers, so I hope that will help when it's finished, we should add that soon.

Thank you.