My customer has asked whether or not we can have an embedded URL within the result set of the wpDataTable plugin.
I currently return data like this:
Rank Name Points
1 John Doe 150
2 Jane Smith 125
I'd like the Name to be a hyperlink to a new query, and with any luck a dynamic sql that would take as a parameter the name, pass it to a new SQL query and display a second table.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
New tables can't be created dynamically, so what you're asking for to achieve can't be done.
You can use dynamic placeholders, though. Please take a look.
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');
My customer has asked whether or not we can have an embedded URL within the result set of the wpDataTable plugin.
I currently return data like this:
Rank Name Points
1 John Doe 150
2 Jane Smith 125
I'd like the Name to be a hyperlink to a new query, and with any luck a dynamic sql that would take as a parameter the name, pass it to a new SQL query and display a second table.
Anyone ever done something like this?
Hello Todd
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
New tables can't be created dynamically, so what you're asking for to achieve can't be done.
You can use dynamic placeholders, though. Please take a look.
You can create a table with a query like this:
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:
After that, you can use a hook for dynamic placeholders:
I hope this helps.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables