Hello Peter

Can you please provide me with a URL to the page where this happens?

Also, tell me are the credentials for your site still the same? 

http://futuremapping.co.uk/wp-login.php

[email protected]

the password you provided in the previous ticket

If they are, also tell me what the table ID is, so I can log in and take a look.

Hey Peter, thanks for the password, that worked.

The issue is coming from the conditional formatting rule:

This applies custom CSS in the background, which only hides the rows from the front-end. This means that they are still present on the page:

But they are hidden with CSS. 

Since this is a manual table, stored in your database, I created a MySQL query-based table TEST SUPPORT where I used the query to pull all records which are not equal to "Completed", and it shows correct number of rows, without the possibility of anyone overwriting the custom CSS applied by conditional formatting.

So, you can now use table #6 to add new data, and configure it the way you want, but you can use the new MySQL query-based table to display it on the front-end.

I hope that helps.

I don't see this as a problem, Peter.

Since the MySQL query table is generated from a manual table, all you need to do is hide the "wdt_ID" column from view (in column settings), enable editing for this table, and choose "wdt_ID" as the editing column, and basically configure it the same way you configured the original table.

So, your users won't even notice the change, other than 25 rows instead of 9 rows, of course.

Hi again Pete

Manual, imported, and MySQL query-based tables are all database tables that use server-side processing, so those tables can handle millions of rows, like this one, for example.

If you have a good hosting plan, having 100 people using the table is not a big deal.

Hey Peter

If you added these as a "Defined values list", the order in which they're added there is the order you're going to see in a select-box or a multi-select-box filter, but the actual sorting inside the column will be done by A - Z sorting order. There's nothing we can do to change that, unfortunately.

I'll forward this as a suggestion to our developers, but most functionalities of wpDataTables are coming from the DataTables jQuery plugin, so until they modify the logic, I doubt there's anything our developers can do about it.