Download
Support
Features
Pricing
Documentation

Select Page

Documentation

Popular Search formimportsqlqueryshortcode

WP Data Access

6

Getting started
Installation
What’s new?
Patches
Known limitations
FAQ

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

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok