---
title: wpdataaccess
description: "Use shortcode **wpdataaccess** to bring database tables and views to your website and WordPress back-end. jQuery DataTables is used to provide dynamic read-only HTML tables supporting pagination, sorting and searching. Choose between flat scrollable and responsive tables. Shortcode ****wpdataaccess**** must…"
url: "https://docs.legacy.wpdataaccess.com/docs/shortcode-wpdataaccess/"
updated: "2025-11-26"
category: Legacy Tools / Code / Shortcodes
---

# wpdataaccess

Use shortcode **wpdataaccess** to bring database tables and views to your website and WordPress back-end. jQuery DataTables is used to provide dynamic read-only HTML tables supporting pagination, sorting and searching. Choose between flat scrollable and responsive tables.  Shortcode ****wpdataaccess**** must be enabled:
 Plugin Settings > Plugin > Shortcode [ wpdataaccess ]

## Data Table shortcodes

  Use Data Tables to create data tables. Every publication has a unique publication id (pub_id) and a unique publication name (pub_name) which can be used in shortcode **wpdataaccess**. Supported shortcode parameters:

- pub_id (publication id)
- pub_name (publication name)
- filter_field_name (field name(s) to be filtered)
- filter_field_value (field value(s) to filter, performs a LIKE and therefor allows wildcards)

### Copy/paste shortcode from a publication

  There's no need to type in the shortcode. The shortcode can be copied from Data Tables to your clipboard and pasted into your page or post:

- Start Data Tables
- Click on link Shortcode
- Copy shortcode to clipboard
- Edit your page or post
- Paste shortcode into your page or post

### Examples

```
[wpdataaccess pub_id="17"]
```

```
[wpdataaccess pub_name="My Publication"]
```

### Inline demo without styling

| Firstname | Lastname | Email | Phone No | Address | Zipcode | City | County | Country |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Firstname | Lastname | Email | Phone No | Address | Zipcode | City | County | Country |

## Filter examples

For security reasons shortcode parameter **sql_where** is no longer available. Please use parameters **filter_field_name**and **filter_field_value**to add a safe filter . The plugin still allows to add a safe where clause on Data Tables data entry page.

```
[wpdataaccess pub_id="6" filter_field_name="job,ename" filter_field_value="president,ford"]
```

```
[wpdataaccess pub_id="18" filter_field_name="lastname" filter_field_value="jose%"]
```

   For filters containing multiple column names and values, use a comma seperated value and make sure the array size of filter_field_name and filter_field_value are the same. The filter allows to use % as a wildcard.

## Styling

- [Premium styling](/docs/premium-styling/)
- [Global styling](/docs/global-styling/)
- [Code Manager styling](/docs/code-manager-styling/)
- [Manual styling](/docs/styling-issues/)