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!
I'm looking for a solution for connecting to a remote MySQL database from a WordPress instance. The database is fully designed and built. There is no need to create tables from the plugin. I'd like the plugin to be able to query and present the queried data in the WordPress site which this plugin seems to be capable of. However, I'd also like to be able to develop a back end CRUD interface in the wp-admin dashboard over the remote database accessing the pre-existing tables. I can't seem to be able to determine whether or not this plugin is capable of doing that. Could someone confirm whether or not this capability exists? If not, is it possible for the client to develop custom user interfaces using the data connections and other objects defined in this plugin once it's purchased, installed and configured?
Thank you.
Hello John
Thank you for your interest in our plugin.
You would be able to query the data, but it would come up in a table view. wpDataTables is a CRUD interface, but everything is done through tables - that's just how it was designed to work.
So, in short - you will be able to run queries and present the results on your website in tabular view using table shortcodes. All changes made in these tables would also be visible in the database tables and vice-versa.
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
Aleksander,
Thank you for this information. It will help in choosing a data access plug in.
I have two more questions:
1. Views exist in the database to help with data presentation. Will it be possible to access these views instead of the underlying tables?
2. Procedures exist to add/update/delete data. Will it be possible to call these procedures and pass parameters in order to add/update/delete data?
Thanks again.
Hi again John
1. You can display the data from those views with simple queries like
So, the table will show only what the view shows.
2. Unfortunately, using variables ( @ ), stored procedures and nested queries is not supported.
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
Aleksandar,
Thanks again for answering my questions! I do have one last question.
If I purchased this plugin and used it to connect to the remote database and utilize the display functionality, would it be possible to leverage the plugin's database connection if I wrote my own add/update/delete interface (i.e. a plugin)? In this scenario, the interface would be calling procedures and passing parameters to those procedures.
Regards,
John Simmons
Hello again John
I believe so, because it would simply store all those procedures in separate database tables, so you could probably use simple queries to retrieve the data defined by those procedures.
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
Aleksandar,
Thanks again for the information. I will be looking at how to implement this plugin soon.
Regards,
John
You're welcome John
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
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