We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
HI
I have knowledge in any of the languages used for web development and sql. I am working on a my-customer-pages for a customer. The customer have bought wpDataTables for that purpose.
As a backend I have developed some php-files. I have logged in customer as a variable in php to use where ever. Customer logins have nothing to do with wordpress users.
My query in wpDataTables looks like this right now:
select * tblInloggFunktion where Kundnr = %VAR1%
I also have a WP shortcode [MittKundnr] that is correct number for %VAR1%.
Now, my question is how do I dynamically change the query in wpDataTables so that the value I have in either php or the shortcode is used?
How would you solve this? Any input is appreciated, thank you.
Hello.
This is a payed license I use. I was expecting to get any response at all in two days. Come on and give me some response at all.
I also have https://wordpress.org/plugins/code-snippets/ installed to be able to write code.
Regards Mattias
Hello , Mattias
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
We don't have this built-in yet, 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:
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 you achieve the results that you need.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi.
Thanks for replying. I will look into that since it may be a better solution than the one I came up with, or what do you think?
I found out that your shortcode "wpdatatable" points to a function "wdtWpDataTableShortcodeHandler" and came up with a snippet like this:
<?php
add_shortcode( 'my_profile_edit', function () {
return wdtWpDataTableShortcodeHandler(array('id' => 1, 'table_view' => 'regular', 'var1' => $_SESSION["Nr"]));
} );
?>
This triggers the same function and sets the var1 to the value I want. I just add [my_profile_edit] as a shortcode in wpress where I want the table.
Regards Mattias
Hi, Matties
It does look pretty neat, so if it works, you can use that as well. The code I shared is for dynamically changing the user ID per a hook for the placeholders. Your snippet seems to do the same thing, so it does look like it should work. Have you tested this?
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Yes, it works :-) At least as long as you guys don't change the name of the function associated with the shortcode.
Regards Mattias
Hi, Mattias
That is awesome! I don't believe we will be changing the name of the function, so should be good to go.
We are delighted to see that it works, of course.
- If anything else happens, please don't hesitate to create new tickets. Have a nice day!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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