Hi Santhosh,

Thank you for your purchase.

Well we don't have this built-in function, but you can try next, but you will need some experience with writing SQL queries and using WP hooks.

You can create table with query for example

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

and then on your_custom_page you will insert shortcode of the tableid that you need with placeholder like this

[wpdatatable id=1 var1=1]

of course, you will create that second table from query like

SELECT * FROM second_table WHERE user_id = %VAR1%

and then you will use our hook for dynamic upsetting 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');

Like this I believe you will get result like you need

Hello Santhosh

SQL covers MySQL, PostgreSQL, MSSQL, so you can choose "SQL query".

You can't add "WHERE Product = %VAR1%" without defining Var1.

If you need to pull everything from table1, and then use VAR as a filtering option in the shortcode, you need to add "%VAR1%" as the predefined filtering value in "Product" column's settings/Filtering tab.

Then, when you use [wpdatatable id=1 var1='product A'] it would work. So in this case you can use simple:

SELECT * FROM table1

No need to add hooks, they are already included in the plugin.

You're welcome, Santhosh

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