Column filter value sorting & hidden columns

Hi,

thanks for your post, and sorry for the trouble.

Just to be sure: Are you referring to the ColumnFilterWidgets Extension (with dropdowns)? That does indeed sort these values as strings — unfortunately, I’m not aware of a direct way to change that ??

As for hidden columns: What method for hiding are you using? Are you hiding the columns on the “Edit” screen, so that they have a red background? Those columns will not be sent to the browser at all, so you’d have to use hiding via CSS code instead. For example, add this to the “Custom CSS” textarea on the “Plugin Options” screen of TablePress:

.tablepress-id-123 .column-4 {
  display: none;
}

Regards,
Tobias

Hi,

Thanks for the CSS hint.

Regarding the filters: Yes, I’m referring to the the ColumnFilterWidgets extension. Will TablePress work with custom DataTables JS code? I’ll try to find a solution in their forums then. In case there’s a standardized way: Do you have an (unrelated) example of how to add multiple, more complex custom commands in the table settings?

Cheers,
Thomas

Hi,

thanks for the clarification! Yes, TablePress will work fine with custom DataTables code. It would either have to be modified in the corresponding JS files (e.g. of the Extension), or added (depending on what is modified) to the “Custom Commands” text field on the table’s “Edit” screen. These “Custom Commands” will be inserted into the DataTables initialization call. Multiple ones can usually be combined with a comma, unless they change the same settings.

Regards,
Tobias

I contacted the developer of the ColumnFilterWidgets plugin. He was surprised it’s still working, it seems the plugin ist not a priority for him anymore an.

Maybe you could consider at some point integrating DataTables “Individual column searching” instead: https://datatables.net/examples/api/multi_filter_select.html?

Best,
Thomas

Hi,

thanks for checking back on this! I guess he used solid APIs which is why this is still working ??

As for the Multi Filter Select: You can actually apply this now already! Just put everything from line 3 to 24 (i.e. the full initComplete function) into the “Custom Commands” text field on the “Edit” screen of your table. Make sure that your table has am empty row at the end and that the “Table Foot” checkbox is checked.

Regards,
Tobias

Right, it already works – thanks!

Cheers,
Thomas

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias
?
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!