Documentation Popular Search formimportshortcodequerysql WP Data Access 6 Getting started Installation What’s new? Patches Known limitations FAQ App Builder 9 Getting Started What’s the App Builder? The App Builder Dashboard App Types Creating A New App Manage App Toolbar Guide: Create A Data Table App Run & Build App Table Builder Form Builder Lookup Wizard Data Tables 36 Getting Started Creating and publishing Responsive data tables SEO friendly data tables Adding hyperlinks Extension Manager Style Manager Language settings Styling Style Manager Premium styling Global styling Code Manager Styling Manual styling Styling issues Filters Static filters Interactive filters URL parameters Search Panes Search Builder Search form Advanced search Geolocation search Export & other buttons Export to PDF, CSV, Excel, SQL Print & copy buttons Column selection buttons Custom buttons Advanced features Advanced settings Large tables & performance Progressively SHOW MORE Custom queries Custom Post Types Row grouping Responsive master-detail Master-detail tables Non admin user access Demos & tutorials Demos Tutorials Data Apps 30 Data Projects Projects and templates Supported Data Types One-To-Many relationships Many-To-Many relationships Registration page Manage table options Shortcode usage Project Templates Project Templates Creating templates Table Settings Relationships List Table Data Entry Reconcile Data Forms Data Forms Overview Project Demo Page Demo Advanced features Adding filters Custom validation Add less/more button User roles Managing roles and users Advanced table options Advanced lookups Front-end toolbar Transfer to other WP site Demos & tutorials Demos Tutorials Data Explorer 19 Getting started Navigation Explore tables & views Manage tables & views Naming conventions Manage Actions Actions Manage Settings Settings Table Settings Column Settings Search Settings Geolocation Settings Dynamic Hyperlinks Dashboard Menus Data Management Import CSV & SQL files Run SQL script files Data Backup Problems & solutions InnoDB #rows estimation Import file too large Transfer to other WP DB Remote Databases 23 MySQL | MariaDB Other DBMS Heterogeneous Connections Using ODBC | JDBC Connect to SQL Server Premium Data Services Remote wizard START HERE Errors and messages Limitations Tutorials Remote Databases Remote databases SQL Server PostgreSQL Oracle MariaDB | MySQL Remote Data Files Remote data files CSV files JSON files MS Access XML files Public URL Synchronization Advanced features Performance Indexes SQL 8 Getting Started Tutorials Visual Query Builder Writing queries Data exchange Stored procedures Database triggers Scheduled queries Business Intelligence 10 Getting started Dashboards Sharing dashboards Dashboards Widgets Dashboard Widgets Publication Widget Project Widget Chart Widget Custom Code Widget Database Widget Sharing Widgets Table Design 3 Getting started Introduction Basic mode Plugin Settings 12 Getting started Plugin Back-end Front-end Dashboard Data Forms Data Tables Data Backup Uninstall Manage Repository Code 29 Shortcodes Overview wpdataaccess wpdadataproject wpdadataforms wpdadiehard wpdageomap wpdawidget Plugin Variables WordPress user ID in SQL Environment variables Hooks & filters Overview Hooks Overview wpda_add_search_actions wpda_add_search_filter wpda_before_list_table wpda_after_list_table wpda_wpdataaccess_prepare Filters Overview wpda_column_default wpda_before_simple_form wpda_after_simple_form wpda_construct_where_clause API WP Data Access API Remote database access CRUD Example Extensions Alternative search algorithm Alternative buttons extension Code Manager Overview Write code Share(d) code
App Builder 9 Getting Started What’s the App Builder? The App Builder Dashboard App Types Creating A New App Manage App Toolbar Guide: Create A Data Table App Run & Build App Table Builder Form Builder Lookup Wizard
Data Tables 36 Getting Started Creating and publishing Responsive data tables SEO friendly data tables Adding hyperlinks Extension Manager Style Manager Language settings Styling Style Manager Premium styling Global styling Code Manager Styling Manual styling Styling issues Filters Static filters Interactive filters URL parameters Search Panes Search Builder Search form Advanced search Geolocation search Export & other buttons Export to PDF, CSV, Excel, SQL Print & copy buttons Column selection buttons Custom buttons Advanced features Advanced settings Large tables & performance Progressively SHOW MORE Custom queries Custom Post Types Row grouping Responsive master-detail Master-detail tables Non admin user access Demos & tutorials Demos Tutorials
Data Apps 30 Data Projects Projects and templates Supported Data Types One-To-Many relationships Many-To-Many relationships Registration page Manage table options Shortcode usage Project Templates Project Templates Creating templates Table Settings Relationships List Table Data Entry Reconcile Data Forms Data Forms Overview Project Demo Page Demo Advanced features Adding filters Custom validation Add less/more button User roles Managing roles and users Advanced table options Advanced lookups Front-end toolbar Transfer to other WP site Demos & tutorials Demos Tutorials
Data Explorer 19 Getting started Navigation Explore tables & views Manage tables & views Naming conventions Manage Actions Actions Manage Settings Settings Table Settings Column Settings Search Settings Geolocation Settings Dynamic Hyperlinks Dashboard Menus Data Management Import CSV & SQL files Run SQL script files Data Backup Problems & solutions InnoDB #rows estimation Import file too large Transfer to other WP DB
Remote Databases 23 MySQL | MariaDB Other DBMS Heterogeneous Connections Using ODBC | JDBC Connect to SQL Server Premium Data Services Remote wizard START HERE Errors and messages Limitations Tutorials Remote Databases Remote databases SQL Server PostgreSQL Oracle MariaDB | MySQL Remote Data Files Remote data files CSV files JSON files MS Access XML files Public URL Synchronization Advanced features Performance Indexes
SQL 8 Getting Started Tutorials Visual Query Builder Writing queries Data exchange Stored procedures Database triggers Scheduled queries
Business Intelligence 10 Getting started Dashboards Sharing dashboards Dashboards Widgets Dashboard Widgets Publication Widget Project Widget Chart Widget Custom Code Widget Database Widget Sharing Widgets
Plugin Settings 12 Getting started Plugin Back-end Front-end Dashboard Data Forms Data Tables Data Backup Uninstall Manage Repository
Code 29 Shortcodes Overview wpdataaccess wpdadataproject wpdadataforms wpdadiehard wpdageomap wpdawidget Plugin Variables WordPress user ID in SQL Environment variables Hooks & filters Overview Hooks Overview wpda_add_search_actions wpda_add_search_filter wpda_before_list_table wpda_after_list_table wpda_wpdataaccess_prepare Filters Overview wpda_column_default wpda_before_simple_form wpda_after_simple_form wpda_construct_where_clause API WP Data Access API Remote database access CRUD Example Extensions Alternative search algorithm Alternative buttons extension Code Manager Overview Write code Share(d) code