Hi tohier,
Thank you for your purchase.

You can find the grouping option when you go to the column setting and on the display tab you will see on the bottom right corner Group column option.

More information in attachment.

Best regards.

Hi tohier,


Can you please tell me if that table is servers side or not?

Grouping columns if the table is server side ( manual or MySQL tables ) is not possible.

Best regards.

Hi tohier,

Can you please delete your post below because the ticket is public and you send me credentials of your site and change them.

When sending the credentials please check PRIVATE reply so nobody can see it except us.

Thank you.

Hi tohier,

As I can see you have 3 tables and all of them are manual.
Manual tables are server side tables and that is why you can not see grouping option.

Please create some not server side table and tell me do you see the groping option.

Best regards.

Hi tohier,

Can you please create any Excel or CSV table and have the integer column in it.

Here is some tutorials so you can see how you can create that tables Excel, CSV.

Best regards.

Hi tohier,

Could you please confirm that this account is administrator level account. This is necessary for me to be able to see plugin and solve the issue.

Thank you.

Hi tohier

I can now see the dashboard.
The new 2.0.2 version is out  You can auto update the plugin by entering the purchase code in wpdatatables settings page or you can manually update the pluign by following this steps:

1.) Download zip from this link

2.) Use FTP to open /yourwordpressfolder/wp-content/plugins

3.) Delete existing wpdatatables folder.

4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)

5.)  Go to WP-admin panel, open Plugins section.

6.) Deactivate wpDataTables, and then activate it again.

You can also take a look at our documentation to see some more information.

I will investigate it after the update.

Best regards.

Hi tohier,

Can you please send me the file from the which you are trying to create a table.


Thank you.

Hi tohier,

When working with Excel-based tables please note: generally they work slower then CSV-files or even Google Spreadsheets, so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL)

I can see that your file is large so my suggestion will be to make MySQL table with server side processing and hard code the grouping function.

To enable Row grouping for serve-side you have to make some changes in file /plugins/wpdatatables/assets/js/wpdatatables/admin/table-settings/main.js around line 739

wpdatatable_config.columns[i].groupColumn = 0;

Just make comments like in code below 

// wpdatatable_config.columns[i].groupColumn = 0;

Please note that after the update of the plugin you will need to change this file again.

Best regards

Hi tohier,

As I understand it does not show all of the numbers correctly if column type is set to string.
Correct me if I am wrong.

Best regards.

Hi tohier,

Can you please check [wpdatatable id=4] on your site that I created.

Best regards.

Hi tohier,

Are those entries correct?


Best regards.

Hi tohier,

Ok, now I can see the issue, sorry for missunderstanding.

Unfortunately the integer column can not start with the 0 as the first number and that is why when you import the table the data is not wright.
When you change that type to string the results are the same like from the file.

Best regards.

Hi tohier,

Can you please give me administrator level account because I need to edit the plugin and see if something can be done.


Or you can made a changes to the file that i told you in the post below.


Thank you.

Hi tohier,

I think we did not understand each other.

Like I said there is no option to have group columns for server side tables. ( That is manual and MySQL tables )

The one issue is that your data from the file can not be integer ( because the integer numbers can not start with the 0 ) but this column can be string.

If you take a look at your first three tables, for example wpdatatables ID 3 you will see that there is a grouping option because the table type is Excel which is not server side table(attachment).
Now the issue is when I try to change some table settings for that table i get this error.

There was an error while trying to save the table! Request Entity Too Large

Request Entity Too Large

The requested resource
/wp-admin/admin-ajax.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

So can you please check your server log and see if there are some errors and also tell me  do you have mod_security installed on your server.

Best regards.

Hi tohier

In regards to a site on your hosting account, the cause of the 406 error is usually due to a mod_security rule on the server.

Mod_security is a security module in the Apache web server that is enabled by default on all hosting accounts.

Apache web server, scans for violations of the rules it has set.

If an action occurs that violates one of these rules, the server will throw a 406 error.

1. If you’re receiving this message when trying to save wpDataTable based on MySQL query from your WP Admin,

it means your hosting provider is restricting access to some of WordPress’ native functionality.

To solve it, contact your hosting provider to ask them to remove this restriction.

2. Adding the following to the top of your .htaccess file. (This should be a temporary measure.

You could try it just to see if it will work, but you probably don’t want to leave it.)

<IfModule mod_security.c>

SecFilterEngine OffSec

FilterScanPOST Off

</IfModule>

3. Backup your .htaccess file if you have one in the public_html directory.

Open the .htaccess file with any text editor and observe the lines between the “# BEGIN WordPress” and “# END WordPress” tags.

Make sure the lines look somewhat like the following. If not then update the file with the following content and upload it to the ‘public_html’ directory.

# BEGIN WordPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

</IfModule>

# END WordPress

Best regards.

Hi tohier,

Unfortunately I can not make any changes to the table because of that mod_security on your server.

Can you please resolve it with your hosting provider I gave you my suggestions in the post below.

Best regards.

Hi tohier,

Unfortunately something like that is not possible.


Best regards.