There was no bigger issue, only a small thing we're aware about because we're working with the plugin on daily basis; so no custom code added, nothing had to be changed anywhere, etc.
It looks like you have mod_security enabled, or you have a security plugin installed which doesn't allow the asterisk ( * ) to be inserted in the query, and that's why it wasn't populating the checkbox filter.
So I just modified your query from this:
SELECT * FROM tommydatabase2;
To this:
SELECT
* FROM tommydatabase2
And everything worked fine. If it's in another row, the security seems to ignore it.
Since your support expired today, let me just say a couple more things about the query, for future reference:
You don't need the semicolon ( ; ) at the end of the Query.
From version 2.3 we implemented a feature that you can use multiple separate DB connections for (MySQL, MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding the accent grave ( ` ). So, when you're generating a query avoid these as well.
I have a problem with Checkbox Filter.
I would like to use the checkbox Filter, but the checkbox filter is always empty. See Image: 1
Several data are contained in the column. see Image 2
Settings are on the image: 3 & 4
Hello AAARob.
I think I got it, so please take a look.
There was no bigger issue, only a small thing we're aware about because we're working with the plugin on daily basis; so no custom code added, nothing had to be changed anywhere, etc.
It looks like you have mod_security enabled, or you have a security plugin installed which doesn't allow the asterisk ( * ) to be inserted in the query, and that's why it wasn't populating the checkbox filter.
So I just modified your query from this:
To this:
And everything worked fine. If it's in another row, the security seems to ignore it.
Since your support expired today, let me just say a couple more things about the query, for future reference:
Please let me know if this works.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables