Hi Daniel,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

1. When it comes to pulling data like this, we can see from your screenshot that the Data source is being stored as JSON format.

When that happens, what you would need to do here is to unserialize the JSON data.

This falls under advanced/custom MySQL, and unfortunately, it will not be covered by our support.

You will have to search for custom solutions online, for example, such as this one from Stack Overflow. 

i hope it helps.

-

And we will just advise a bit more in general details about pulling data from ACF.

At the moment, we don't have native a built-in/native integration with a plugin such as ACF, so pulling data from that plugin into wpDataTables would have to be done with custom MySQL query-based tables.

Please note: 

Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge.

 Please be advised that preparing MySQL queries for you is not included in the plugin support.

2. When it comes to the counter where it shows the data has been filtered;

I presume this is a table based from an SQL Query?

Did you add any "WHERE" clause / in your SQL Query where you would insert a certain condition?

If you added a "WHERE" function, then our Plugin is going to consider what is the total number of rows from your source SQL Table, and then it shows how many rows are filtered from it.

-

An example from our Demo Table dummy_employees, if i just do :

SELECT * FROM dummy_employees

Then it says "showing 100 out of 100 rows".

But if i add the WHERE, like :

SELECT * FROM dummy_employees
WHERE position='Designer'

In that case, it shows how many rows where in Total before the "WHERE" statement filtered it.

3. Is there any chance to import in wpdatatable more than 61 columns from Custom Post?

When it comes to a limit for Columns, our Plugin does not have any limit, but WordPress itself has limits and each Hosting Server also has its limits when it comes to how many rows and columns it can handle.

When our QA Team did testing, on our servers we were able to do around 50 columns, i believe, and we did not encounter any issue, so we can't say an approximate general limit when it comes to how many Columns can WordPress and Hosting servers handle without becoming very slow or crashing a Page.

I think it will be difficult to create more than around 50 to 60 columns in DataTables without reaching over some PHP limits from WordPress Hosting servers, but can't say with 100% certainty.

To mitigate this, you can try increasing PHP limits on Hosting server, such as  PHP TimeOut Limit, PHP Memory Limit and so on, but it can help only to a certain degree.

Another thing you could try is using our server-side processing.

Try placing as little rows by default as possible to lessen the load on the hosting server.

You will see this option in the Table's display settings/Default rows per Page.

So if you have an SQL Table with server-side processing enabled, and a low number of Default Rows Per Table page, that will use AJAX to load only that X number of rows at a time, to help with performance.

But, as i said, it will always multiply how many columns you got times how many rows, and then it will load all those cells.

-

You could also try using our Master-Details Add-on to see if that could help.

It can be used if you wish to first present an initial table with less data/ less columns;

then if a user makes an action you set up,  it can load "more details" only for the selected row

(1. If the “Row click” is selected, users will be able to access details for a row by clicking on it. 

2. If the “Button click” is selected, a new column will be added to the table, where each row would get a button opening the details for it.)

-

You an also set up in which way you wish the details to load;

1. It can be as a Pop Up to reveal more columns of that row

2. A template Post with placeholders

3. Or a template custom Wordpress Page with placeholders to load data for more columns of that row.

Please check more about Master Details here, with an example.

-

You can also test Master Detail Add-on features on this sandbox site.

-

Lastly, you can try the Powerful Filters Add-on with "Hide Table before Filtering" option.

This prevents any Query from running until a user chooses one or more filters on your Table.

Then it only loads the filtered selection, in some cases that can help with the load.

-

My apologies once again for replying so late.

We don't work on weekends, and we extended our Orthodox Christmas holiday until the 8th of January, so we are just getting back up to speed today.

Thank you for all your patience.

Let me know if you have any additional questions.