The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several formats are available on mouse click. Table data can be viewed and managed from list tables and user friendly data entry forms. Many settings can be managed from the Data Explorer to customize table and view management.
More complex features are available for experienced developers, like remote database access and executing SQL scripts. Remote database access is supported by all features.
Features #
- Manage local and remote databases
- Estimated row count support for large tables
- Row-level access control for improved security
- Explore and manage table data
- Execute SQL script files
- Export to SQL, JSON, XML, CSV and Excel (unlimited size)
- Import from SQL and CSV
- WordPress media library integration
- Dynamic hyperlinks
- WordPress role management integration
- Unattended scheduled exports
- Optimized to support large tables
- Transfer data to another WordPress database
Hi Peter,
On this page:-
https://wpdataaccess.com/docs/data-explorer-settings/table-and-view-settings/
you have an example table with images of motor bikes (just above the sub-heading “Dynamic hyperlinks”). In the left column, you have a green button with a “plus” symbol, and a click on the green button displays additional fields from the current data record. I would like to replicate this construction, as I have one table, which has about 22 columns. I want to display 5 or 6 columns in the table, with the other 15 or 16 only displayed for just one record, when the user clicks on a button. Can you say where this construction is described in the documentation?
Thanks in advance for your help.
Nigel
Hi Nigel,
To add the + icon you just need to make your publication responsive and enter a 0 in the number of columns field.
Hope this helps,
Peter
I would like to know if the plugin allows creating a table from the database and filtering the data by user. The table will contain data from multiple users, but I want it to display only the data of the user viewing the table.
Hi David,
You can use the MySQL session variable @wpda_wp_user_id anywhere in your SQL code. This feature is documented here:
https://wpdataaccess.com/docs/remote-databases/wordpress-user-id-in-sql/
Additionally, you can add your own unique session variables, as explained at the bottom of the page.
The App Builder allows you to add a filter to the default where clause of an app. This is documented here:
https://wpdataaccess.com/docs/table-builder-filters/default-where/
Hope this helps,
Peter