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!
Hallo.
I follow the Public Ticket # 1053203 I would like to ask if there has been any progress in displaying MySQL data using stored procedures (using CALL). It would be enough for me to read the data.
He will not. Do you have an example of showing data from some simple stored MySQL procedure, in another way?
Thank you.
Hi jiri,
Thank you for your purchase.
Sorry for late response. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Unfortunately the SQL box in the plugin isn't intended to work with anything except for SQL queries, it won't support stored procedure calls. It expected to receive an SQL query on the back-end, and the query is edited on the back-end side, this logic breaks when there's something else in there (var definition, stored procedure calls, etc.).
You can try to make a VIEW in phpmyadmin or any other database management system and see if the query is returning some result. Then make a table from query
SELECT * FROM view_name.
Also what we could suggest (if you do want to call a stored procedure every time on table read) is to use one of the plugin's hooks: http://wpdatatables.com/documentation/information-for-developers/hooks/ http://wpdatatables.com/documentation/information-for-developers/filters/
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
yes, I have already read this answer in the Public Ticket # 1053203. But since I am not so experienced in wordpress programming, please ask for some simple example to display a table from MySQL simple stored procedure. Perhaps it should go with the "wpdatatables_filter_initial_table_construct" filter. The wordpress database objection is called $wpdb, what is the name of the object for separating mysql connection?
Hi jiri,
Like we said before our plugin with built in features won't support simple or complicated stored procedure calls at the moment. Filters and hooks are helpers for developers to make some new functionality of plugin. It is assumed that you have some knowledge of wordpress programming for using them. You can get a detailed description on WordPress hooks here in WP Codex.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
Okay, you have at least some, any example using the wpdatatables_filter_initial_table_construct filter. Somehow you had to try it. You would be very good if you sent it to me.
Thank you, J.Knotek.
Hi jiri,
We used wpdatatables_filter_initial_table_construct filter in handler for the table shortcode in file
wp-content/plugins/wpdatatables/controllers/wdt_functions.php around line 423 and you can see how it works.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank You.
Hi jiri,
You are welcome.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables