Since updating to wpDataTables 2.2 (and 2.2.1), Multiselctbox column filters are no longer working properly. On the web pages, they simply don't respond to user mouse clicks. They do seem to work on the back end.

Checkbox filters and text filters work OK. The problem seems to be limited to multiselect box filtering.

The "Show X" entries dropdown does not function on the web pages either. The user is no longer able to change this from the default values that is set on the back end.

I didn't know filtering was possible without the add-on, but yes, the add-on is on

Yes please send the patched version.

Is this your recommended approach, rather than backing out of wpDataTables 2.2.1 to an older version that is still compatible with Powerful Filters?

There is not change in behavior after replacing Powerful Filters 1.0 with 1.0.1. The multiselect box still does not function, and neither does the "Show X" rows selector.

Now I can't set up pre-defined filter values anymore either. The option remains "grey" and inactive no matter what other configuration options I choose.

Should I regress to wpDataTables 2.1?

It still won't build a checklist or multiselect list. The lists are empty.

I think the closing semi-colon on the sql statement is the culprit. multiselect droplists are working properly too now that I have omitted the semi-colon

Yes. Everything is working fine now. It was closing my queries with ";" that was causing the issues. Perhaps you could add a tool tip to the interface warning users about this?

Thanks for your help.

Bogdan,

It seems this isn't resolved entirely yet.

While the select and multiselect filters and the Show XX entries options work properly in the back end (table preview), only the select filter operates on the web pages (front end). If I build a multiselect filter and select it on the front page, nothing happens. The same is true of the Show XX entries select list. These last two just simply do not function at all.

Milan,

That did it! Thanks so much for the help.

Don

Milan,

Maybe I spoke too soon.

Now the checklist and multiselect forms are populated, but the pop up seems to completely disable the page. I can't select anything, reset the popup, or close it. I have to refresh the page to regain access to it. 

However, the Show XX entries drop list is functioning now.

I cannot. The server is behind a firewall and requires vpn access.

As an alternative, can you tell me how your development or test environment is configured? What themes do you commonly use?

I have cloned my site to a development environment and disabled all plugins except wpDataTables and powerful filters and changed the theme to Twenty Seventeen. Now the filters work properly on the front end. 

Next step is to restore theme and plugins one by one till I find the conflict.

It seems to be an issue with the theme.

I had been using WP Invictus theme, but I can't tell why there is a conflict.

I would like to use a theme that has a full width template so I can fill the screen with my charts. Do you know of one that works with wpDataTables and powerful filters that does not conflict?

You should be able to download the them from wordpress.org. The name of the theme is "WP Invictus"

It works! Thanks a lot for all your help.