As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1881734
Error Checkbox Filter
Closed

Comments

  • AAARob started the conversation

    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


  •   AAARob replied privately
  •  2,576
    Aleksandar replied

    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:

    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.

    Please let me know if this works.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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