Hello John.

Thank you for your purchase.

Using filters and hooks is not included in the provided support for the plugin as it requires a certain level of programming skills.

Here's an example for you, but you need to replace it with values from your tables if you have an SQL query based table:

SELECT * FROM wp_wpdatatable_1

You can use the hook to display only certain columns, like this:

function table_filtering($query,$table_id) {
if ( $table_id == 3 ) {
    $query = "SELECT * FROM ht_clientinfo where clientID = '9444'";
}
    return $query;
}
add_filter('wpdatatables_filter_mysql_query', 'table_filtering',10,2);

But, why wouldn't you do this with placeholders instead? It should be a simpler solution.

So, you can assign %VAR1% as a predefined filtering value to clientID column (under column settings/filtering), and then change it through the shortcode:

[wpdatatable id=1 var1=9444]

Hi again John

We don't have this built-in yet, but you can with a workaround. Please note that this does require some experience with writing SQL queries and using WP hooks.

You can create a table with a query like this:

SELECT user_id, user_name, user_address,
CONCAT('<a href="http:/yoursite.com/your_custom_page?user_id=',user_id,'">Details</a>') AS Details
FROM your_table_name

Then, on your_custom_page you will insert a shortcode of the table ID that you need, with a placeholder like this:

[wpdatatable id=1 var1=1]

The second table would be created from a query like this:

SELECT * FROM second_table WHERE user_id = %VAR1%

After that, you can use a hook for dynamic placeholders:

function updateVAR1($tableID){
  global $wdtVar1;
      //check is set GET parametar user_id
    if(isset($_GET['user_id'])){
        //get value from form fieald
        $wdtVar1 = $_GET['user_id'];
    }
  }
add_action('wpdatatables_before_get_table_metadata', 'updateVAR1');

I hope this helps you achieve the results that you need.

Hello John

1. You need to assign %VAR1% to something. In order to filter a certain column per value of %VAR1%, that needs to be added as a predefined filtering value in the column:

2. If there's only one table on the page, it doesn't require the table ID.

3. It's not required, but you can add it, if you have multiple tables on the same page, of course.

Hello John

You're looking at the placeholders tab above the table, while my screenshot is from Column Settings/Filtering.

The %VAR1% value should remain empty if you don't want the table to be automatically filtered with it when you add "%VAR1%" to column settings, under "Predefined filtering value" because you'll pass its value in the shortcode.

Please let me know how it goes.

This looks good.

So, to sum up - if you added %VAR1% as a predefined filtering value in clientID column, these shortcodes should do exactly what you ask:

[wpdatatable id=3 var1=1] show user with ID:1

[wpdatatable id=3 var1=9] show user with ID:9

Thanks for that, John

I forwarded the ticket to one of our developers, and as soon as I hear something I will let you know.

Hi again John.

Our developer could only see that the PHP global variable has been forwarded as a string.

Please try this:

$query = "SELECT * FROM ht_clientinfo where clientID = '" . $client . "'";

Hello John.

If you're referring to loading the pages for the first time, and there's no forwarded GET parameter, then yes, since in the logic (in your function) you're asking if the GET parameter is set, and if it isn't, the client variable will be empty; it then goes into your second condition, where it asks if the table with ID3 is (the one on the page) and packs the query with an empty client variable, and that's why you're getting the empty table on load.

Only the GET parameter is being forwarded by clicking the link in the first table, as far as we can see.

It may be better to change the logic, only if the clientid is set, and if there's a table with ID3 on the page, to pack the query. Something like this:

function table_filtering($query,$table_id) {
 global $client;
   //check is set GET parametar clientID
   if(isset($_GET['clientID'])){
       //get value from form field
      $client = $_GET['clientID'];
      if ( $table_id == 3 ) {
         $query = "SELECT * FROM ht_clientinfo where clientID = '" . $client . "'";
      }
   }
   return $query;
}
add_filter('wpdatatables_filter_mysql_query', 'table_filtering',10,2);

I'm sorry to disappoint you, John, but creating custom queries is not included in the provided support for the plugin.

They can check the code you added, though. Can you clone your website?

If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.

If the Duplicator plugin fails (the free version works for sites up to 500MB), you can use the All-in-One WP Migration plugin.

The files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.

Also, make sure to provide us with a detailed description - which table is this for, on which page is it located, which theme is being used, and what exactly do you need from it?

Please note that this is a public ticket, so make sure to enable the PRIVATE response.

Hi again John

This filter definitely works, as it's been sent to other customers before you multiple times. You're still passing the variable as a string, that's why an integer (5040) works, but a string (h;adek5040) doesn't work. You need to adjust the code for a string.

Our developers will gladly take a look at this, and try to find the issue in your code, but they need to see everything that you see - so, since the Duplicator failed, can you please use the All-in-One WP Migration plugin to duplicate your site?

Again, we'll need a detailed description - which table is this for, on which page is it located, which theme is being used, where the code is, and what exactly do you need from it?

Thanks, John.

I forwarded it to our development team, and as soon as I hear from them I will let you know.

Hello John

I apologize for the late response.

We're missing one of the database tables in the duplicator "ht_clientinfo". Can you please just access your database using phpMyAdmin (or any other tool that you may be using for database management), export that table, and send it to us?

Make sure to enable the private response when you respond.

Thanks John, I forwarded it to our development team, and as soon as I hear from them I will let you know.

Hello again John.

Sorry for the late response.

You don't need the hook for the MySQL query if this is what you need.

String data wasn't returned into VAR1 because you didn't add the single quotes around the placeholder in the query.

When this is modified, you'll not be able to save the table because you set the clientId as the value of VAR1, and it doesn't exist. Change that and include an existing value from the table as long as the table is generated. Then, on the page crudeditclient add the shortcodes of the two tables that you need, and for the table client info forward the value of VAR1 (for example test, or anything else if you need this table to be without data on the load of the page). Then, when you click on details above the table in the client info table, the GET data will be forwarded and the table will be filtered. Please check the attachments.

If this is not what you need, please explain the flow in more detail so we can see how it can be done.

I'm glad to see you guys were able to work together on this.

John, I just want to know if there's anything we can do for you about the issue from the title of the ticket, or should we consider this resolved?

Seems fine to me, John, thanks for sharing that with everyone!

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.

Hi Graham,

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.

-

Since this is a very old ticket, we are not sure if we will be able to contact John / if he will see our new correspondence here, but we should be able to help you with your use-case.

Also, in the meantime, we released quite a few Updates to our Plugin with some new Features/options, although we did not release any new major options on this subject of using filtering with Placeholders, etc.

-

The best way to handle this situation is, if you can please open a new ticket and show us more details along with screenshots, what kind of Table did you make, we presume an SQL Query based Table;

And how did you setup your Placeholders, we presume you will be using one of the VAR placeholders with the Query, right?

And also, do you plan to use a Custom Hook as John did in order to pull a filtering value from a GET parameter, etc?

If you can elaborate in more details about your specific use-case, and add any screenshots, or even better, a Video, that can help.

If the images or Video show any sensitive Data, please send it as a PRIVATE message, for safety, then only we can see it.

And if you make a Video that is large for an attachment, just upload it to weTransfer and send us a download link.

Thank you.