Hi Ryan,

Sorry, I did not fully understand your use-case/goal.

Could you please elaborate in more details/ show me some more details as screenshots/or even better, a Video to display how your source data is structured, how the initial Table should look, versus how it should look with the 'drill-down' reports?

-

Did you check out our Master-Details Add-on, maybe it can be useful, but i am not sure what you need exactly?

The add-on Master-Details can be used if you wish to first present an initial table with less data/ less columns;

then if a user makes an action you set up,  it can load "more details" only for the selected row

(1. If the “Row click” is selected, users will be able to access details for a row by clicking on it. 

2. If the “Button click” is selected, a new column will be added to the table, where each row would get a button opening the details for it.)

-

You an also set up in which way you wish the details to load;

1. It can be as a Pop Up to reveal more columns of that row

2. A template Post with placeholders

3. Or a template custom Wordpress Page with placeholders to load data for more columns of that row.

Please check more about Master Details here, with an example.

-

You can also test Master Detail Add-on features on this sandbox site.

Let me know how that seems,

or if you need something different entirely for your use-case?

If you send us any Screenshots or a Video that show sensitive Data, just make sure to mark the reply as PRIVATE, then only we can see it, for security reasons.

Or if a Video gets too large, you can upload to weTransfer and send me a download link.

Thank you.

Hi Ryan,

Thank you for this clarification, I can understand the use-case.

You can achieve it with our Plugin and Master-Details, it will just require certain SQL skill and we will show you a custom workaround example of a "master-child" relation with Master-Details Add-on.

First, you need to create the button (master-detail) column in your existing table with the 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 our dynamic 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 we try to be as detailed as I can when passing the explanation from our Developers, so you can understand what and how you can achieve with this.

Please note that custom solutions with hooks like this require a certain level of programming skills, and included support refers only to advice.

Let me know if this fits your needs.

Thank you.