Hello Philippe

Unfortunately, this will not work for multiple tables on the front-end as the filter will be applied to all filters with the same ID (in your case filter [1]).

You can, however, assign the value %VAR1% as a predefined filtering option for the "Sensor Name" column and then pre-filter the table through the shortcode.

So, [wpdatatable id=12] will return the non-filtered table, but [wpdatatable id=12 var1=mini] will add "mini" as a filter to this column. Instead of using the URL for the filter, you'd be using the placeholder.

That is correct, Philippe, 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.

Hey John

I just responded to your open ticket: https://tmsplugins.ticksy.com/ticket/2878207/

Please take a look at it, and let me know on that ticket if you have any further questions.