Hello Sebastian

I don't know if I understood this correctly.

You want an entry from the table to appear in the MD modal as a hyperlink that would take the visitor to the specific post or page? That link would be dynamically generated by the content of the cell, right?

If that's true, you could use the CONCAT function, like this:

SELECT column1,
        column2,
        CONCAT('<a href="www.yourwebsite.com/page1/',yourTable.column3,'">',yourtable.column3,'</a>') AS Hyperlink
FROM yourTable

This will create a hyperlink to www.yourwebsite.com/page1/value1 if there's "value1" entered as cell data in column3. On another row, it could be www.yourwebsite.com/page1/value2 if there's "value2" in the cell, and so on.

So, this would be a hyperlink which could be shown in the modal, and it would take the user to the respective page.

Hi again Sebastian

Since Master Detail is actually using data from the table, you would need to create a column where data would be saved in hyperlinks.

So, you would use the CONCAT function, to append the partial URL to the value of a column.

Do you actually have pages that would be used in the URL? For example, if your ID column has 1, 2, 3, 4, 5, and you have pages:

www.yourwebsite.com/pageid=3

You can use the concat function like this:

CONCAT('<a href="www.yourwebsite.com/pageid=',ssg_main.id,'">',ssg_main.id,'</a>') AS Hyperlink
FROM yourTable

Side note: when you're pulling data from one table in a query, there's no need to include the table's name before column names, and there's no need to use accent graves ( ` ), as that may cause issues with search and filtering. Since you have spaces in the column names (also not recommended in SQL), you need to use accent graves, but please reconsider changing the column headers to be in one word.

Hi again Sebastian

You can't have both - page and modal. It simply can't work with the built-in features of the plugin.

A) If you enable the modal; and want to forward the link from a modal to the MD page, that won't work, because there's no data to be fetched from the modal, and output in the page. Meaning, you would see only the placeholders in the page.

B) Same as A) - if the page is accessed directly, not through the table, it will only show placeholders, not the data pulled from the table.

Please check out this idea of Master-Detail parent/child relation - it may help:

First you will create that button column in your existing table with MD add-on and then set custom page where users will be redirected after click.

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

If you have that table in database then fine you ill use it for creating new table with SQL query and placeholders.

 IF you create manual table then you will use table that is created in database(you can find it on Editing tab on MySQL name table for editing). 

Those table have names like wp_wpdatatable_1,wp_wpdatatable_2...

You will use then those table to create new one with query. 

So you will create new table like this

SELECT * FROM table_name_from_mysql_name_option WHERE column_name = %VAR1%

Then on that custom page will 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 dynamic 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 user click on More details button(that you will create with MD) it will be redirect on your custom page(that you set in MD).

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

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

I hope that I am not confused you with this, but I try to be details as I can to understand what and how you can achieve with this.

Let me know is this fit for your needs.

Hi again Sebastian.

2. The approach would be this:

In the first table, you enable Master-Detail, so it opens in a new page. On that page, you add the SQL query based table, which also has Master-Detail configured. So, with previously configured VAR placeholder, you would add that table on the Master-Detail page using a shortcode like [wpdatatable id=1 var1=customValue]. So, after that, in the hook you forward the parameter.

This does require some knowledge of hooks and filters, and is not included in the provided support for the plugin.

What you describe in #3 should work fine, but the query doesn't look correct. You should create a new table with:

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

So, the query displays fun_wpdatatables table where some_column = the placeholder. That placeholder needs to be defined in the Placeholders tab above the table, so the table has something to generate. Add any value that exists in the table, since you'll later change that dynamically.