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?
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
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?
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.
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.
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.
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