Hello Andrew

Sorry for the late response.

There are wpDataTables that work with millions of entries, so I don't believe that's the case.

You may want to increase the following:

upload_max_file size, 

post_max_size,

max_execution_time

You should be able to find these values in your php.ini file or on your hosting panel. If you can't find it yourself please ask your hosting provider to provide it.

Other than that, you may want to look at your server's performance, hosting plan and the amount of other data you have on your pages. SQL query based tables (that don't pull ALL data onto a page) should work normally. Maybe a bit slower than non-server-side (smaller) tables, but work all-in-all.

Hello Andrew

Using the built-in features of the plugin will not be able to do this, however there is a workaround using this hook:

wpdatatables_before_get_table_metadata( $tableId )

Although, there is a bug on our end, and I'll have to ask you to bear with me to get it working properly.

The action is called correctly when modifying a table in the backend, but if you have the same table rendered from the front-end the action is not called correctly.

If you change a global variable within this action - works in the backend, in the front-end the default value is used:

function testSetVar1toMNR($MyTable){
  global $wdtVar1;
  //get Column from Plugin
  $lMNR = do_shortcode('[ihc-user field="CUSTOM_FIELD_column"]');
  //Found?
  if ($lMNR>0) {
   $wdtVar1 = $lMNR; //Set VAR1 custom parameter to column
  }  else  {
      $wdtVar1 = "9999";
 //Default to 9999 --> needed for Admin Context
     }
       }
add_action('wpdatatables_before_get_table_metadata', 'testSetVar1toMNR');

Unfortunately at the moment I can offer only this Hot-Fix with non desired-side-effects:

public function fillFromData($tableData, $columnData) {
        if (empty($tableData->table_type)) {
            return;
        }
        global $wdtVar1, $wdtVar2, $wdtVar3;
    //test: Change 31.07.2019 to update placeholders in production mode
  //needs default value for admin-context, otherwise breaks table creation
  do_action('wpdatatables_before_get_table_metadata');
        // Set placeholders
        $wdtVar1 = $wdtVar1 === '' ? $tableData->var1 : $wdtVar1;

….SNIP

Here:  class.wpdatatable.php

I hope this helps.

After a new update is released, you won't need to add the hot-fix, though.

Actually, Andrew,

We've had a new update is released, so you won't need to add the hot-fix.

The first part of the code goes into functions.php of your theme, while the other part of the code goes in ../wp-content/plugins/wpdatatables/source/class.wpdatatable.php. You can look for "public function fillFromData" in that file (should be around line 2722), and overwrite it.

Please save a copy of the original file, just in case something goes wrong, so you can restore it.

To be able to pass variables dynamically through URL, you should try something like this:

And in the browser:

That would return "10" and overwrite the original %VAR1% value.

Hi again Andrew

This goes into functions.php:

function testSetVar1toMNR($MyTable){
  global $wdtVar1;
  //get Column from Plugin
  $lMNR = do_shortcode('[ihc-user field="CUSTOM_FIELD_column"]');
  //Found?
  if ($lMNR>0) {
   $wdtVar1 = $lMNR; //Set VAR1 custom parameter to column
  }  else  {
      $wdtVar1 = "9999";
 //Default to 9999 --> needed for Admin Context
     }
       }
add_action('wpdatatables_before_get_table_metadata', 'testSetVar1toMNR');

Since the update was released, the second code is no longer necessary.

Hi Andrew

Please provide me a temporary WP-admin login 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 party. 

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

Hi Andrew.

Thank you for the credentials. However, they are not Administrator level credentials:

Can you please make that an admin role, and let me know?

Hi Andrew.

Aleksandar is out of office today and I will help you out.

We check your website, and we notice that you only copy and paste code for hook that is the example from other customer needs which is the reason why your tables with placeholder VAR1 is not working. (attachment)

Another this that we found in table with id 88 is that you are using in condition Parent instead of parent. (attachment)

Please note that using hooks and filters requires some programming skills so you can adopt functionality for your needs.

If you want to filter the table with URL parameter you need to change hook example that Aleksandar provide to you.

Here are some advices in comments

function setVar1fromURL($tableID){
    global $wdtVar1;
    //get URL parametar
    $varFromURL = $_GET['wdtVAR_1'];
    // Here is the condition that ask is that URL parameter set
    // Code like this will be executed for every table with SQL query
    // If you need for specific table then you will need to provide additional code
    // for example you want to filter only table with id 1 then
    // you will replace  if (isset($varFromURL)) { with this  if (isset($varFromURL && $tableID == 1)) {
    if (isset($varFromURL)) {
        $wdtVar1 = $varFromURL; //Set VAR1 with parameter from URL
    }
    // if your condition is not true then this code below will be executed
    // reason why your tables is not working because $wdtVar1 is always set to 9999
    // if URL parameter wdtVAR_1 is not set
    // if you don't need it you can remove it
    // This is example for some other customer needs so you need to adopt for your needs
    else {
        $wdtVar1 = "9999"; //Default to 9999 --> needed for Admin Context
    }
}
add_action('wpdatatables_before_get_table_metadata', 'setVar1fromURL');

Hi again Andrew

Can you please share the code you've added with us?

As a reminder - you cannot simply copy the code. You need to adjust it for your needs. The code we've provided is just an example.

Hi again Andrew

It doesn't work in back-end because the GET parameter is not set.

Remove this:

$varFromURL = $_GET['wdtVAR_1'];

And ask directly for GET:

if (isset($_GET['wdtVAR_1'])) { $wdtVar1 = $_GET['wdtVAR_1']; }

If the GET parameter isn't set per this code, VAR will be set to 9999, so you need to set the value you need, or remove it if you don't need the value for a GET parameter that isn't set.

Hello again Andrew

You're correct, it's because of the query. The parser is not able to parse it since it's too complicated.

You should try to create a MySQL view, which would hold the query. Unfortunately, you wouldn't be able to use the placeholders in the view, because it wouldn't work. You would need to create something like:

SELECT * FROM view WHERE some_column= '%VAR1%'

Or something like that.