Ian Sadovy

Hello @rweil55,

Thank you for the answer.
As for the views, I will try to add your suggestion somewhere in the docs.

Regards,
Ian

Hello @rweil55,

Thank you for writing.
Actually, WPTables supports custom MySQL queries starting from version 1.3.2.
Does it work for your case or your suggested workaround works better?

Regards,
Ian

Hello @terrence-lp,

Thank you for the question.
To run the query for the different databases on the server, please make sure that the MySQL user for wordpress db also has read permissions for other databases you want to access. It can be done by using PhpMyAdmin or GRANT statement.

Hope it helps.

Regards,
Ian

Hello Cedric,

Thank you for reporting and sorry for the troubles.
By inspecting the view-wptables-list-tables.php file I have found out that it uses PHP 5.4 syntax for creating an array – https://take.ms/gPgwn . Since all the classes are declared when the plugin is activated, it will throw the syntax error if PHP < 5.4. Still, I cannot understand how it can be connected to the shortcode.

Sorry again.

Regards,
Ian

Hello @igvol,

The main purpose of the wptables_mysql_query filter is to allow using custom variables in the MySQL query:

1. You define the query in the admin and use some special placeholder that you want to be replaced dynamically while executing. For example, if you want to show the table with data only for current month: SELECT * FROM sales WHERE date > $current_month
2. Then, you define filter in the PHP (i.e. functions.php) to replace $current_month with actual date:

   add_filter('wptables_mysql_query', 'my_custom_query');
   function my_custom_query($query) {
     return str_replace('$current_month', date('Y-m-01'), $query);
   }

On the other hand, if you want to allow your users to filter the data dynamically on the front-end, it may be connected to the following thread – https://www.ads-software.com/support/topic/custom-filter-2/

Hope it helps.

Regards,
Ian

• This reply was modified 7 years, 1 month ago by Ian Sadovy.
• This reply was modified 7 years, 1 month ago by Ian Sadovy.

Hello @varpenny,

I have added a fix based on your suggestion in the latest version.
You are welcome to update.
Please let me know if it works well.

Regards,
Ian

• This reply was modified 7 years, 1 month ago by Ian Sadovy.

Hi Mike,

I have published a new version, you are welcome to update.

Regards,
Ian

Hello Mike,

Thank you for reporting. Sounds really helpful, I already have few pending fixes for the export, so I will include this as well in the next update.

Thanks,
Ian

Hello @sune1612,

Thank you for the question.
Currently, there is no filtering feature in WPTables.
I have an idea of adding filtering as a separate extension but do not have any estimates for that. If something changes I will update you here.

Hope it helps.

Regards,
Ian

Hello @varpenny,

Thank you for reporting and for providing a possible solution.
I will review the code and include the fix in the next public update, so you will be able to update WPTables safely.

Hope it works.

Thanks,
Ian

Hello @lahormig,

Thank you for the suggestion. It sounds reasonable.
I will take a look how the editing experience can be improved.

Thanks,
Ian

Hello @mrheffner,

Thank you for the question.
I’ve got it, and your suggestion about setting ID in the shortcode sounds reasonable.
I will definitely do this in the next update. For now, as a workaround, you can use .jsgrid-table selector to access the table via jQuery. If you have more than 1 table on the page, you may also specify the index of the table, i.e. jQuery('.jsgrid-table').eg(1).

Please let me know if it helps.

Regards,
Ian

Hello Perry,

Thank you for the review.
Great news for you, you can add/remove a row by right-click context menu – https://take.ms/djLHg

Hope it helps.

Regards,
Ian

Hello @mrheffner,

Thank you for the question.
Allow Selection enables the highlighting effect when you move your mouse over the row.
Please refer to the video – https://take.ms/4MIre

Hope it helps.

Regards,
Ian

Hi Simphiwe,

Glad to hear that, thank you!

Regards,
Ian