Please wait...

wpDataTables Settings

Video versionSee a video tutorial on configuring the plugin

Main settings tabMySQL connection, skin, data formats, and other primary plugin settings

Use separate MySQL connection

Enable this setting if you want to build tables using data from DB or host which is different from the one that you use for your WordPress installation.

Do not check this checkbox if you want to use the WordPress database connection.
If you set this checkbox to checked, you will also need to provide the following data in order to be able to query the MySQL database:

  • MySQL host: The address of MySQL host, domain or IP-address.
  • MySQL database: The name of the database that you would like to use.
  • MySQL user: Username which will be used for login.
  • MySQL password: The password which will be used for login.
  • MySQL port: if you use a non-standard (different from 3306) port on your MySQL server you can define it here.
  • Test MySQL connection: use this button to check if the settings are correct.

Interface language

wpDataTables comes with 45 world languages for the main interface features (provided by jQuery DataTables internationalisation). You can have the interface translated to your language by just choosing the language from this selectbox.
Important Only the main table features are covered by this package. It means that table tools (“Copy”, “Print”, “Excel”, …) and advanced filtering labels aren’t translated, but you can translate them yourself if you want.

Tables per admin page

Here you can set how many tables will be visible in the “Browse wpDataTables” admin page. Same setting is used for “Browse wpDataCharts”.

Base skin

wpDataTables has two built-in skins that you can use. Here you can choose one of them.

Filters position

Here you can choose where the column filter will be rendered (if you do not decide to put it in a separate widget for some particular tables): in the table footer, or in the header.

Date format

This selectbox allows you to choose from 11 common date formats which will be used for the date columns, and for all responsive datepickers.

Number format

Here you can choose the output format for the numbers: which sign to use for thousands separator, which for decimals.

Decimal places

Here you can define how many decimal places will the floats have, so they would all get rendered in a similar manner.

Align numbers to the right

If this checkbox is checked, all numbers will be aligned to the right in the table columns.

Tablet width

Here you can redefine the width that the plugin will “see” as the tablet width. Can be used if you want to trigger responsive mode on desktops as well.

Mobile width

Here you can redefine the width that the plugin will “see” as the mobile device width.

Purchase code

Item Purchase Code from envato. Used for authentication for auto-updates, and is not mandatory.

Color and font settings tabConfiguring the plugin frontend design

Here you can find a list of settings which will allow you to change the look of the tables rendered by the plugin. You can change:

  • Table font color
  • Header background color
  • Header border color
  • Header font color
  • Header active and hover color
  • Table inner border color
  • Table outer border color
  • Even row background color
  • Odd row background color
  • Hover row color
  • Cell color in active (sorted) columns for even rows
  • Cell color in active (sorted) columns for odd rows
  • Background color for selected rows
  • Buttons background color
  • Buttons border color
  • Buttons font color
  • Buttons background hover color
  • Buttons hover font color
  • Modals (popups used in the plugin) font color
  • Modals font color
  • Modals background color
  • Overlay background color (a background below popups which overlays the site content when they appear)
  • Buttons hover border color
  • Buttons and inputs border radius (in pixels, if you would like to have them rounded)
  • Table font

You will find a short explanation beside each style setting, so you would know what element does it change.

Custom JS and CSS tabConfiguring Javascript and Stylesheets for the plugin

Custom wpDataTables JS

Here you can define any custom javascript that you want to be executed on the pages that have wpDataTables. E.g. auto-refresh, or something like that.

Custom wpDataTables CSS

Here you can define any CSS rules that you want to be applied on the pages that have wpDataTables. For example hiding the search block, pagination, etc.

Use minified wpDataTables javascript

By default the minified files are attached to the pages. But you can uncheck this if you want e.g. to modify the javascript – it’s much easier to edit the unminified files.

Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.