This usually happens for MySQL-based tables with server-side processing turned on.
Please check if you have a complicated query with JOINs, calculated columns (for example, ” SELECT mycolumn*2 AS mycolumn2″), or some custom column aliases (e.g. “SELECT mycolumn AS ‘some/weird/name’). If this is the case, please either create a MySQL view (in PHPMyAdmin or similar MySQL DB manager) and build a wpDataTable based on this view.
From version 2.3 we implement feature that you can use multiply separate db connections for (MySQL,MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave (`). If you use this accent grave (`) in your query, please remove it and searching and filtering will work fine.
You can check out the video and step by step guide on this YouTube link
If you like to have invisible columns in filters, that can be achieved by enabling “Filter in form” option in table edit page.
“Filter in form” option will create filters as a separate section from the table and additionally show filters for all hidden columns.
You can choose which column filter will be visible/hidden by unchecking/checking the “Add a filter for this column” button in the column settings for the desired column.
Tables can be filtered with a query string that consists of “wdtColumnFilter[KEY]” value pairs where KEY is a zero-based numerical index of the column you would like to filter or initial column header. For example:
?wdt_column_filter[1]=Asia&wdt_column_filter[country]=Thailand
Values passed from URL will be used as default filter values, therefore “Advanced filtering” option needs to be enabled on table edit page.
If you need to pre-filter the table via global search just open the page adding a key to the URL:
?wdt_search=filtervalue
Where ‘filtervalue’ is the value you would like to insert into the filtering field. This would pre-filter the table via global search.
Just add this code below in Custom wpDataTables CSS under the “Custom JS AND CSS” in main settings of wpDataDables.
.wpdt-c .wpDataTablesWrapper table.wpDataTable thead {
display: none !important;
}
This will be affected on all tables, but if you want just for specific one then insert this code on the page where is that table between the style tag (<style>Code here</style>)
<style>
.wpdt-c .wpDataTablesWrapper table.wpDataTable thead {
display: none !important;
}
</style>
For customization of layout for options Calculating totals, minimum, maximum and average cells in wpDataTables you can use this selectors:
.wdt-sum-cell, /* for totals */ .wdt-avg-cell, /* for average */ .wdt-min-cell, /* for minimum */ .wdt-max-cell, /* for maximum */
