[Plugin: WP-Table Reloaded] Hiding & sorting columns

Hi,

yes, that explanation is correct. The solution is to switch to a (relatively) new and better parameter for this: aoColumnsDef instead of aoColumns (https://datatables.net/usage/columns). That new parameter is independent of the actual number of columns, and should work on both pages:

"aoColumnDefs": [ { "sType": "html", "aTargets": [ 0, 4 ] }, { "sType": "date", "aTargets": [ 2 ] } ]

Regards,
Tobias

Thank you, Tobias!

When using either aoColumns or aoColumnsDef in combination with hide_columns, I sometimes get this error when loading the page with the embedded table:

DataTables warning (table id = 'wp-table-reloaded-id-2-no-1'): Requested unknown parameter '5' from the data source for row 0

Do you know what might cause that?

If I remove the hide_columns parameter, the error goes away.

–Ken

Hi Ken,

on which page does this happen?

Regards,
Tobias

Tobias,

My table has 8 columns with these custom commands:

"aoColumnDefs": [ { "sType": "html", "aTargets": [ 1, 6 ] }, { "sType": "date", "aTargets": [ 4 ] } ], "bAutoWidth": false

I display 7 columns without issue here:

https://www.open-apple.net/ebay/

using this shortcode:

[table id=2 print_description=false first_row_th=true hide_columns="8" column_widths="8%|15%|10%|14%|12%|8%|33%%" use_tablesorter=true /]

For the purpose of testing, I’ve created this page that calls five columns:

https://www.open-apple.net/testing-wp-table-reloaded/

using this shortcode:

[table id=2 print_description=false first_row_th=true filter="Show14" hide_columns="1,3,8" column_widths="15%|14%|16%|12%|43%" use_tablesorter=true /]

(I sometimes use shortcode parameters that are redundant with options I’ve set elsewhere… LMK if that’s an issue.)

-Ken

Hi,

thanks for the examples.

The problem is that “6” in the “Custom Commands”. That “6” targets the 7th column of the shown table. However, when hiding some columns (i.e. 1, 3, 8), there are only 5 columns visible. Due to that the JavaScript code fails.
So, as it seems the idea with the new aoColumnDefs doesn’t work with this specific structure of your table. It would work with the example code that you posted above, but not with this table ??

(And: Those Shortcode parameters are no problem.)

Regards,
Tobias

Thanks, Tobias. It sounds like if I rearrange the columns so all the ones with special types are within the first six, it should work. I’ll give it a try.

Hi,

Yes, exactly. As long as the column numbers in the “Custom Commands” (zero-based counting) don’t exceed the number of columns (in the small table), it should work.

Regards,
Tobias