Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
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