A new feature was added to perform global search and replace actions on multiple databases and tables. The new feature can be accessed from the new Search & Replace icon (see image below) in the menu bar of the Data Explorer and is available for all users (free...
What’s new?
Posts under the "What’s new?" category
Copy/export large tables
When a table is copied or exported, the plugin needs to read and write all table rows. For large tables this might result in a fatal error:Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes)One way to solve this issue is to...
Copy table to other DB
A new feature was added to the Data Explorer, which allows users to copy a table to another local or remote database. The current database is selected by default. It is still possible to copy the table with or without data.Copying large tablesThe query buffer size,...
Hide Data Explorer Manage link
Restrict table management is a new option available in plugin back-end settings. It allows organizations to remove the Manage link in the Data Explorer for specific admin users. See image below (click to enlarge).Many plugins require WordPress users to have the...
Data Tables CSS changed
Icon color greenThe Data Tables library file structure has changed in version 5.1.1. If you are using one of the Code Manager styles (or copied the styles into your WordPress theme), the responsive icons will be shown in its original green color instead of the color...
Repository backup and restore management
WP Data Access creates a backup of all your repository tables each time the plugin is updated (unless disabled). This mechanism was added to prevent plugin users losing their repository data during an update failure. It has now been extended to allow plugin users to...
Improved performance for large tables
Tables are using pagination by default. Although pagination improves the user experience, it slows down performance, especially for large tables. Pagination requires counting: All table rows All matching table rows The pagination features were optimized in version 4.2...
Added freemius library to WP Data Access plugin
Starting from version 3.5.0, WP Data Access uses the freemius library to bring the plugin to the next level…What is freemius?New WP Data Access releases will be available in two version: a free version and a premium version. Freemius is a tool that helps to maintain...
Add user input filter to where clause
Starting from version 3.1.5, the plugin allows to add a filter to a where clause based on user input: Add an argument to your request (supports POST and GET) Give your argument the name of your column prefixed with wpda_search_column_ ExampleAdds condition
Publications are now fully responsive
To create a fully responsive publication: Open your publication in Data Tables Set output to responsive Set number of columns to 0 Save your publication If you want all devices to show the same (fixed) number of columns, set number of columns > 0 (= number of...
Recent Comments